Senin, 21 Maret 2016

Query : Pagination Mysql Server dan MYSQL

MySQL Server 

Select TOP ".$endRow."*
From tb_m_Cust a
inner join tb_m_CustType b
on a.m_CustType_ID=b.CustType_ID
where a.Cust_ID IS NOT NULL

and a.Cust_ID NOT IN
(
Select TOP ".$startRow."  a.Cust_ID
From tb_m_Cust a
inner join tb_m_CustType b
on a.m_CustType_ID=b.CustType_ID
order by KD_Cust desc

ORDER BY  

MYSQL 
kalau dalam MYSQL cukup menggunakan LIMIT $end,$start

Tidak ada komentar:

Posting Komentar