创建视图,实现某一字段去重,同时有一列主键(ID)自动递增 SQL SELECT RANK() OVER (ORDER BY a.SYSNM) AS ID, a.SYSNM FROM ( SELECT DISTINCT SYSNM FROM ENTITY_WBXTYHXXLR ) AS a 结果 IDSYSNM1测试系统2开发系统3生产系统