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