last 10 records

Results 1 to 3 of 3

Thread: last 10 records

  1. #1
    Join Date
    Dec 1969

    Default last 10 records

    can anyone help me with this sql query.i have to display the last 10 records using asp.the database is access.thanks in advance

  2. #2
    Franco Guest

    Default RE: last 10 records

    A quick and dirty way to do it is to use the primary key value. If you have UserID as your primary key then you can say:<BR><BR>"SELECT x,y,z WHERE UserID&#062;MAX(UserID-10)"

  3. #3
    Join Date
    Dec 1969

    Default thanks a lot franco

    thanks a lot worked.

Posting Permissions

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