Axapta Code solutions Earn Money its Real
Query to delete duplicate records from table using sql
select * from test where exists (select * from test as t where test.id=t.id having count(*)>1 and min(t.id) !=test.id.);
I hope you get my point.
If you are not able to get correct solution then you can visit link below to apply some query in different ways.
http://blog.sqlauthority.com/2009/06/23/sql-server-2005-2008-delete-duplicate-rows/
Query to delete duplicate records from table using sql
select * from test where exists (select * from test as t where test.id=t.id having count(*)>1 and min(t.id) !=test.id.);
I hope you get my point.
If you are not able to get correct solution then you can visit link below to apply some query in different ways.
http://blog.sqlauthority.com/2009/06/23/sql-server-2005-2008-delete-duplicate-rows/
0 comments:
Post a Comment