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;