delete duplicated records
-
Hi all, i have one table, it does n't have identity column,primary key,foriegn key,unique key and no constraints. Now i want to delete duplicate records. ex: table : sample (before deletion) cno cname salry 10 xxx 1000 10 xxx 1000 10 xxx 1000 20 yyy 2000 20 yyy 2000 i want the result like this after deletion: cno cname salary 10 xxx 1000 20 yyy 2000 Please help me.
-
Hi all, i have one table, it does n't have identity column,primary key,foriegn key,unique key and no constraints. Now i want to delete duplicate records. ex: table : sample (before deletion) cno cname salry 10 xxx 1000 10 xxx 1000 10 xxx 1000 20 yyy 2000 20 yyy 2000 i want the result like this after deletion: cno cname salary 10 xxx 1000 20 yyy 2000 Please help me.
Take a look at this: http://www.databasejournal.com/features/mssql/article.php/1438651
Gautham
-
Take a look at this: http://www.databasejournal.com/features/mssql/article.php/1438651
Gautham
Hi gautham, Thanx for your response.
-
Hi gautham, Thanx for your response.
-
Take a look at this: http://www.databasejournal.com/features/mssql/article.php/1438651
Gautham
http://www.databasejournal.com/features/mssql/article.php/1438651[^]
Learning is not a spectator sport. - D. Blocher