Delete just one record

Results 1 to 2 of 2

Thread: Delete just one record

  1. #1
    Adrian Guest

    Default Delete just one record

    I&#039;m making a cart ad if there is two of the same records and someone wants to delete just one how can i do this?<BR>Currently I just say WHERE id= &#039;"&id&"&#039; but this will delete both if two have the same id.<BR>So how can i delete just the first one?<BR><BR>-Adrian

  2. #2
    niraj Guest

    Default RE: Delete just one record

    which database you are using for storing the recods if oracle then there is a rowid <BR>field in each table by which you can delete the record<BR>delete * from table_name where rowid not in(select min(rowid) from table_namegroup by repetative_fieldname

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts