摘要:
declare @page int=3;declare @perpage int=20;SELECT UserID, PostTime, rid FROM ( SELECT UserID, PostTime, rid=ROW_NUMBER() OVER(ORDER BY PostTime) FROM ( SELECT UserID,PostTime,rowid=ROW_NUMBER() OVER(PARTITION BY UserID ORDER BY PostTime DESC) FROM Activity..OnlineMatch2th WHERE PostDate='2011-8 阅读全文
摘要:
/* 方法一*/SELECT 序号= (SELECT COUNT(客户编号) FROM 客户 AS LiMing WHERE LiMing.客户编号<= Chang.客户编号), 客户编号, 公司名称FROM 客户 AS Chang ORDER BY 1;GO/* 方法二: 使用SQL Server 2005 独有的RANK() OVER () 语法*/ SELECT RANK() OVER (ORDER BY 客户编号 DESC) AS 序号, 客户编号, 公司名称FROM 客户;GO/* 方法三*/SELECT 序号= COUNT(*), LiMing.客户编号, LiMing.公司 阅读全文
摘要:
--------------------------------- -- Author: liangCK 小梁 -- Title : 查每个分组前N条记录 -- Date : 2008-11-13 17:19:23 --------------------------------- --> 生成测试数据: #T IF OBJECT_ID('tempdb.dbo.#T') IS NOT ... 阅读全文