sql排序赋值 https://www.cnblogs.com/ilxx1988/p/5579753.html

云逸@

已于 2022-09-01 11:35:17 修改

阅读量502

点赞数

文章标签： sql 数据库

于 2022-09-01 11:04:04 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_42592992/article/details/126639186

版权

本文探讨了绿色日托中心的数据表单中，如何使用ROW_NUMBER()和DENSE_RANK()函数进行数据行号和重要性排序，涵盖了ID、人数、时间等关键信息，便于管理和分析日常运营数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT
  ROW_NUMBER() OVER (partition by gd.id ORDER BY gd.id desc) AS '序号',
	gd.id,
	gd.number,
	gd.xzqh,
	gd.xzqh_code,
	gd.yhpq,
	gd.yhpq_code,
	gd.people,
	gd.zyrc,
	gd.jxtb,
	gd.jxczrs,
	gd.yhcl,
	gd.time,
	gd.username,
	gds.work,
	gds.work_num,
	gds.unit 
FROM
	greenDayCare gd
	LEFT JOIN greenDayCareSon gds ON gd.number= gds.number 
WHERE
	1 = 1
	order by gd.time desc：

在这里插入图片描述

SELECT
  dense_rank() OVER ( ORDER BY gd.id desc) AS '序号',
	gd.id,
	gd.number,
	gd.xzqh,
	gd.xzqh_code,
	gd.yhpq,
	gd.yhpq_code,
	gd.people,
	gd.zyrc,
	gd.jxtb,
	gd.jxczrs,
	gd.yhcl,
	gd.time,
	gd.username,
	gds.work,
	gds.work_num,
	gds.unit 
FROM
	greenDayCare gd
	LEFT JOIN greenDayCareSon gds ON gd.number= gds.number 
WHERE
	1 = 1
	order by gd.time desc

在这里插入图片描述