当前位置：网站首页>常用sql记录

常用sql记录

2022-08-09 14:11:00 【渐暖°】

获取年工作日

SELECT
	DATEPART ( YY, jobdate ) 年,
	DATEPART ( mm, jobdate ) 月,
	count( * ) 工作日 
FROM
	jobrecord_workday 
	where DATEPART ( YY, jobdate )='2022'
GROUP BY
	DATEPART ( YY, jobdate ),
	DATEPART ( mm, jobdate )

sql根据id去重

with infos as
(
SELECT ROW_NUMBER() OVER ( PARTITION BY Infoid order by id desc) rowNum ,
*
FROM [InfoTops] t1 with(nolock)
)
select * from infos where rowNum=1   ---------------》