常用sql记录

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

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   ---------------》