answersLogoWhite
Software and Applications (non-game)
Database Programming
Windows XP
MySQL

How you delete duplicate row of table in SQL?


Top Answer
User Avatar
Wiki User
2008-09-22 22:05:42
2008-09-22 22:05:42

This can be different depending on the SQL server involved. Please specify the Database being used (ie, mysql, postgresql, oracle, ms SQL Server) I am using SQL 2005 express, what is the command, i can only get... delete... and what else? lets say i want to delete a duplicate row that is row 2.

Related Questions

User Avatar

You drop the table and the row is deleted along with it.

User Avatar

you right click it and you scole down to delete row in oracle table that should work

User Avatar

Each row in a table starts with the <TR> tag, and the cells are started with the <TD> tags which are inside the TR tags. To remove a specific row just highlight, and delete from <TR> to</TR> for example a table with two rows might look like this: <Table> <TR> <td>first row</td> </TR> <TR> <td>second row</td> </TR> </Table> To remove the first row delete <TR> <td>first row</td> </TR> You will be left with: <Table> <TR> <td>second row</td> </TR> </Table>

User Avatar

delete from table_name where(rowid,0) in (select rowid,mod(rownum,2) from table_name) this is for alternate deleting even row delete from table_name where (rowid,1)in(select rowid,mod(rownum,2)from table_name)this is for alternate deleting odd row

User Avatar

An SQL Update Statement is one that changes the data of one more records in a table. One could change a complete row, or select which to change. One could find how to do this at WebCheatSheet.


Copyright © 2020 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.