数据库去重的几种方式 ROW_NUMBER ( ) OVER ( ) SELECT NVL( T.WYTJ, '无' ) CODENAME, NVL( T.WYTJ, '无' ) CODEVALUE FROM ( SELECT T.WYTJ, ROW_NUMBER ( ) OVER ( PARTITION BY T.WYTJ ORDER BY T.WYTJ ) AS A FROM EP_BASE_BKS_ZCCJ T ) T WHERE T.A = 1 原文地址