Re: sql query(try again) [message #375057] |
Mon, 23 July 2001 02:55 |
Shukla
Messages: 5 Registered: July 2001
|
Junior Member |
|
|
hi mathew,
thanks for ur response. but you didn't get the actual problem.i want all those rows which are duplicate of original rows.actually i want to delete these rows while preserving original rows.
suppose my table contains following records:
col1 col2 col3 col5
----------------------------------
shukla 2 3 4
shukla 2 3 4
shukla 2 3 4
mathew 1 3 5
bobby 4 3 8
---------------------------------
then my query should return:
col1 col2 col3 col5
----------------------------------
shukla 2 3 4
shukla 2 3 4
----------------------------------
please try again..
shukla
|
|
|