tsong zone
Software engineer in telecommunication industry share out experience
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;
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)