SQL Server单条sql实现分页和总行数

最新推荐文章于 2020-11-20 02:16:20 发布

weixin_34236497

最新推荐文章于 2020-11-20 02:16:20 发布

阅读量519

点赞数

文章标签：数据库 python java

原文链接：https://my.oschina.net/shma1664/blog/709567

版权

2019独角兽企业重金招聘Python工程师标准>>>

SQL Server单条sql实现分页和总行数

SELECT
	CustomerId AS customerId,
	Phone AS userMobile,
	Name AS userName,
	FirstOrderTime AS firstOrderTime,
	LatestOrderTime AS lastestOrderTime,
	CustomerLevel AS customerLevel,
	Call400Count AS call400Count,
	OnlineOrderCount AS onlineOrderCount,
	CityId AS cityId,
	CityName AS cityName,
	total AS totalNum
FROM
	(
		SELECT
			CustomerId,
			Phone,
			Name,
			FirstOrderTime,
			LatestOrderTime,
			CustomerLevel,
			Call400Count,
			OnlineOrderCount,
			CityId,
			CityName,
			ROW_NUMBER () OVER (ORDER BY CustomerId DESC) rn,
			COUNT (1) OVER () AS total
		FROM
			CustomerInfo WITH (NOLOCK)
		WHERE
			1 = 1
	) AS t
WHERE
	1 = 1
AND t.rn BETWEEN 1
AND 20

转载于:https://my.oschina.net/shma1664/blog/709567