表结构
要求
查询出无重复GLRDM的GLRDM、GLRMC数据
SQL
SELECT
a.GLRDM,
a.GLRMC
FROM
( SELECT b.*, row_number ( ) over ( partition BY GLRDM ORDER BY GLRDM ) AS idx FROM GLR_INFO b ) a
WHERE
a.idx =1
表结构
要求
查询出无重复GLRDM的GLRDM、GLRMC数据
SQL
SELECT
a.GLRDM,
a.GLRMC
FROM
( SELECT b.*, row_number ( ) over ( partition BY GLRDM ORDER BY GLRDM ) AS idx FROM GLR_INFO b ) a
WHERE
a.idx =1