[Database][Mysql/SQLServer/Oracle] Limit Query Record

Deskripsi
     Me-limit atau membatasi jumlah keluaran record yang diquery.

How To

// mysql

select col from tabel limit 10;

// Oracle

// Oracle has a system attribute ROWNUM for each record returned.

select col from tabel where rownum <= 10;

// Microsoft SQL

select top 10 col from tabel;