oracle根据列查询不重复的行

表：TEST_ORDERY

col1 col21     11     21     32     12     33     14     15     15     26     2

oracle根据列查询不重复的行


查出记录为：

col1     col21         12         13         14         15         16         2

oralce语句为：

SELECT * FROM TEST_ORDERY WHERE rowid IN (SELECT min(rowid) FROM TEST_ORDERY GROUP BY COL1) order by col1,col2;