Friday, October 8, 2010

Differences database sql statement on result set limit

// mysql
select col from tbl limit 20;

// Oracle
select col from tbl where rownum<=20;

// Microsoft SQL
select top 20 col from tbl;

No comments: