Unanswered: Is there an equivalent syntax to TOP IN SQL?
Hi everyone, I am new to SQL, and would really appreciate help with this.
I have a database with the following fields:
IDNumber: sequential running from 1 to approx 50000
I want to return the last 100 IDNUmbers and return the surname and fname associated with the IDNumbers.
When I try TOP it gives me IDNumbers 1 to 100, is there an equilvant for the bottom 100 numbers.
Please help if you can.
Return the top 100, but just order by IDNumbers DESC
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert