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

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