kosenrufu
asked on
What is the SQL to select first 100 records?
What is the SQL to select first 100 records?
Currently I am using SELECT TOP 100 but this gives me records that have the same value in the descending field
Thanks
Currently I am using SELECT TOP 100 but this gives me records that have the same value in the descending field
Thanks
post a copy of the db and explain, which records you want to see using a select top 100 query..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.