Teknik Paging : syntax query untuk membatasi jumlah baris dari hasil query

Di MySQL menggunakan 'LIMIT baris_awal, jumlah_baris'
contoh : SELECT namafield FROM namatabel ORDER BY namafield ASC/DESC LIMIT baris_awal, jumlah_baris


Di Oracle menggunakan ROWNUM
contoh : SELECT F.* FROM (SELECT *, ROWNUM rnum FROM
(SELECT namafield FROM namatabel ORDER BY namafield) F
WHERE ROWNUM <= jumlah_baris) WHERE rnum >= baris_awal

Di SQL Server
Contoh : Select TOP jumlah_baris * From namatable
where id NOT IN (Select TOP baris_awal id From namatable )

sumber : https://www.facebook.com/groups/programmervbindonesia/permalink/10151160487374271/

68 independent days