【Vegas原创】select时，一个栏位按123进行编号的方法

2年前 (2022) 程序员胖胖胖虎阿

193 0 0

SQL2005提供了新函数：ROW_NUMBER（）

以下为示例：

select ROW_NUMBER() OVER(ORDER BY sAMAccountName DESC) as emp_no,
        '' as card_no,sAMAccountName as ename,sn+givenname as cname,
       '' as Gender,'' as departmentname,'' as job_Rank,telephoneNumber as ext,
        Mail as email,'' as dlidl,'' as enter_date,'' as birth_date,'1' as workstate,'DTS' as domain
from [eipdb].webeip.dbo.ldap_account
where replace(sAMAccountName,' ','') not in
(select distinct replace(ename,' ','') from empBaseInfo)

版权声明：程序员胖胖胖虎阿发表于 2022年11月3日下午3:16。
转载请注明：【Vegas原创】select时，一个栏位按123进行编号的方法 | 胖虎的工具箱-编程导航