SELECT
ID,TSRID, plid,CustomerName,SellCode,Mobile
,ReserveTime,CrtTime,hjtime,jieshuma ,
InsureBillCode,
tname,bname,shoucang,xingbie,ActivityName ,sydate,AddInsuranceID
FROM
-----------------------------------------------
(
SELECT *,ROW_NUMBER() OVER (ORDER BY hjtime desc) AS RowNo
FROM [C_V_SellData]
where
CrtUser=358
and StoreType=1
and EndCode <>
1
and EndCode <> 5
and hjtime >=
cast(convert(varchar,‘2014/1/18‘,111) as datetime)
and hjtime
< cast(convert(varchar,‘2014/2/18‘,111) as datetime) + 1
and
isnull(AddInsuranceID,‘‘)<>‘N‘ ) AS A
--------------------------------------------------
WHERE
RowNo>=1 and RowNo<=50
sql server 2008 rownumber 分页sql语句
原文：http://www.cnblogs.com/zyf/p/3554409.html