select row_number() over(order by zip1 asc) as tt ,zip1 from hc_cust where zip1 <> '' --直接排序 select row_number() over(partition by zip1 order by zip1 asc) as tt ,zip1 from hc_cust where zip1 <> '' --單一群組內各自做排序 select rank() over(order by zip1 asc) as tt ,zip1 from hc_cust where zip1 <> '' --同群組同號碼,下一群組跳號 select dense_rank() over(order by zip1 asc) as tt ,zip1 from hc_cust where zip1 <> '' --同群組同號碼,下一群組接號 -------------------------------------------------------------------------------------------------- SELECT CONVERT(VARCHAR(10), DATEADD(week, DATEDIFF(week, 0, getdate()), 0), 111) AS 本周一 SELECT CONVERT(VARCHAR(10), DATEADD(week, DATEDIFF(week, 0, getdate()), 5), 111) AS 本周六 SELECT CONVERT(VARCHAR(10), DATEADD(week, DATEDIFF(week, 6, getdate()), 0), 111) AS 上周一 SELECT CONVERT(VARCHAR(10), DATEADD(week, DATEDIFF(week, -6, getdate()), 0), 111) AS 下周一 DECLARE @myDate as DATETIME SET @myDate = DATEADD(week, ...