oracle 去除重复的信息 

SELECT S.SSLH as sslh4598_0_,
       S.QSH as qsh4598_0_,
       S.PYSJ as pysj4598_0_ 
  FROM SIS_XG_QSXSPY S
 WHERE RESOURCE_ID IN  (SELECT MIN(RESOURCE_ID) FROM sis_xg_qsxspy GROUP BY qsh)

 

posted @ 2013-01-18 17:01  不经意的回眸  阅读(115)  评论(0)  编辑  收藏  举报