Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007

    Cool Unanswered: Delete the 10 last records(lines)

    Hallo and thanks in advance!

    i'have the Table with the columns:x,y,colors

    . number . number . number.

    full of values.

    witch query i can use to delete the 10 last records(lines)
    if i don't know any of the numbers i ve got there???

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    There is no concept of "last 10" without the use of the ORDER BY clause
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    The most accurate way would be using one of GUI tools which would enable you to, actually, SEE those records and delete the ones you think you should.

    As you don't know which records to delete, all you can do is guess if you insist on deleting through a query, something like

    DELETE your_table WHERE ROWNUM < 11;

    Or, if you finally found out how to distinguish them so that you could write an ORDER BY clause, it would be possible to include it into a query and finally delete right records.

Posting Permissions

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