LIMIT ROWS RETRIEVED USING SQL 1

[Queryman]

Can someone post an example of how to limit the number of rows retrieved, not sure what the command is (LIMIT, TOP etc). Needs to be ANSI SQL.
Thanks!

QueryMan

 

[mwolf00]

SELECT TOP 100 * FROM emp


SELECT TOP 50 PERCENT salary FROM emp ORDER BY salary DESC -- Just trying to help...
<--- This is a wolf? We need a new icon.......
mikewolf@tst-us.com

 

[r937]

mike, he said ansi sql, TOP is microsoft P-)

queryman, you can't do it in ansi sql unless you give a column to sort on, and then it becomes a variation of the &quot;top ten&quot; query (which, by the way, is not very efficient):

SELECT PERSON, SCORE
FROM SAMPLETABLE XXX
WHERE 10 >
( SELECT COUNT(*)
FROM SAMPLETABLE
WHERE SCORE > XXX.SCORE )

rudy