Depending on your situation, you may be able to have a cursor loop through the rows and use a "DELETE FROM myTable WHERE CURRENT OF myCursor" and then break out of the loop once you've deleted the first row.


------------
SATYA at 8/28/01 3:32:19 PM

hai
I have to delete a single row from a table , where there are multiple rows with the same data and i want to delete only one row and i cannot alter my table
structure.
Thanks in advance
satya