110,566
社区成员
发帖
与我相关
我的任务
分享
string.Format(@"SELECT A.* FROM (
SELECT TOP {0} *, ROW_NUMBER() OVER ( ORDER BY 排序字段 ) AS RowNumber
FROM 表) A
WHERE A.RowNumber BETWEEN {1} AND {2}
ORDER BY A.RowNumber",PageIndex * PageSize,(PageIndex - 1) * PageSize + 1, PageIndex * PageSize);
SELECT A.* FROM (SELECT TOP 10 qy_QBase.*,
qy_QSumInvite.qsi_QinviteIDs, qy_QSumInvite.qsi_Posts, ISNULL(qy_QSumInvite.qsi_ReceiveNum,0) AS qsi_ReceiveNum, qy_QSumInvite.qsi_UpdateTime, qy_QSumInvite.qsi_SalayRange,
ROW_NUMBER() OVER ( ORDER BY qy_QSumInvite.qsi_UpdateTime DESC, qy_QBase.Q_ID DESC ) AS RowNumber
FROM qy_QBase
LEFT JOIN qy_QSumInvite ON qy_QBase.Q_ID = qy_QSumInvite.Q_ID
WHERE Q_IsVerify = 1 ) A
WHERE A.RowNumber BETWEEN 1 AND 10
ORDER BY A.RowNumber