SELECT TOP 10 col FROM table #### SELECT col FROM table FETCH FIRST 10 ROWS ONLY #### SELECT col FROM table A WHERE 10 > (SELECT COUNT(*) FROM table B WHERE A.col < B.col) ORDER BY col DESC