How can I limit the number of SQL SELECT rows

מתוך R63
קפיצה אל: ניווט, חיפוש

mysql

select col from tbl limit 20;

Oracle

select col from tbl where rownum<=20;
SELECT f_name, l_name, age from employee_data where rownum between 21 and 40 ORDER BY age DESC  <<< ????


Microsoft SQL

select top 20 col from tbl;

כלים אישיים