View Single Post
  #3 (permalink)  
Old February 2nd, 2004, 06:02 AM
qwjunk qwjunk is offline
Authorized User
 
Join Date: Jan 2004
Location: , , .
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default

it deletes both the occurences .. im not sure if im applying the rowid part correctly ..

this is what is used..

delete from table where FILE_NO in ( select min(FILE_NO) from patient where FILE_NO = 89523)

i want the second occurence to be deleted ...
Reply With Quote