Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Other Development Tools
 query to delete a similar row

Author  Topic 

mahesh423
Starting Member

9 Posts

Posted - 2008-09-30 : 09:11:34
In a Table i have no primary keys ..
so any no of same rows can be inserted into it.
if in a case 2 rows are similar,then how can i keep one row after delete the rest..?
any solution for this..?
if data is not sufficient,then plz let me know..
thanks

Mahesh Kumar

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-09-30 : 09:13:52
Are you still using SyBase?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111591


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -