当前位置：网站首页>Common sql records

Common sql records

2022-08-09 15:33:00 【Warmer °】

Get the weekday of the year

SELECTDATEPART ( YY, jobdate ) year,DATEPART ( mm, jobdate ) month,count( * ) weekdaysFROMjobrecord_workdaywhere DATEPART ( YY, jobdate )='2022'GROUP BYDATEPART ( YY, jobdate ),DATEPART ( mm, jobdate )

sql deduplication according to 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 --------------span>-"