这条SQL语句怎么用分页?

[qingang1983]

我想分叶.取得100条到120条的记录就很难了.
select Top 20*,QT_CardID,QT_CardMONEY,QT_ChargeMemo,convert(char(20),QT_ChargeDate,20) QT_ChargeDate,c.QT_BindPhone from QT_Charge_list as l left join QT_Customer as c on l.QT_ID =c.QT_CustID where 1=1 order by QT_ChargeDate desc

[tomyuansir]

select top 20 * from tablename(即可以是语句也可以是表名) a where id not in(select top 100 id from tablename(即可以是语句也可以是表名) b)

[tomyuansir]

select top 20 * from tablename(即可以是语句也可以是表名) a where id not in(select top 100 id from tablename(即可以是语句也可以是表名) a)

纠正一下

[yinhongyan]

去找邹建的通用分页的存储过程吧