// mysql
select col from tbl limit 20;
// Oracle
select col from tbl where rownum<=20;
// Microsoft SQL
select top 20 col from tbl;
SQL Select Limit
Wednesday, March 18, 2009
Posted by ayus at 9:43 PM 0 comments
Subscribe to:
Posts (Atom)
// mysql
select col from tbl limit 20;
// Oracle
select col from tbl where rownum<=20;
// Microsoft SQL
select top 20 col from tbl;
Posted by ayus at 9:43 PM 0 comments
Menulis bukan untuk berkongsi ideologi, sekadar nota kecil buat bekal diri.
(c)Ayus 2008 de Abu Faaris | Lawati web utama di Nursyuhada.com