sql去掉多条重复只显示一条
摘要:
SELECT occud04,occ14 FROM (SELECT occud04,occ14,ROWNUM AS a1 FROM ds1.my_occ_file_view WHERE occud04 IS NOT NULL AND occ14 > 0 AND occud54 = '1' AND o 阅读全文
posted @ 2020-08-22 18:19 chenzhe1 阅读(522) 评论(0) 推荐(0) 编辑