Results 1 to 2 of 2

Thread: Finding the unique....

  1. #1
    SATYA Guest

    Finding the unique....

    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


  2. #2
    Tammy! Guest

    Finding the unique.... (reply)

    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


Posting Permissions

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