First 10 records?

[rastkocvetkovic]

How to output first 10 records in 2000 record table... I'm confused because of mySQL LIMIT 10, access' TOP 10 and so on. Please help ASAP!

 

[r937]

select foo, bar
  from yourtable xx
 where 10 >
       ( select count(*)
           from yourtable
          where foo > xx.foo )

here "foo" is the column that would be in the ORDER BY clause when you use LIMIT or TOP

in english, this query selects every row where 10 is greater than the number of rows that have a higher foo

caution: ties are included, so you might get 11

rudy

http://rudy.ca/