用sql取表中的前n個或後n個記錄
隨手寫下,方便自己記憶
informix :
select first 2 s33cseq
from lbs33c
order by s33cseq;
oracle:
select *
from z01
where rownum<=10
order by z01usrid ;
sql server :
Select top 1 GuestName
From SmsGuest
order by GuestName ;
(未測試,沒裝sql server)