col1 col2
1     1
1     2
1     3
2     1
2     3
3     1
4     1
5     1
5     2
6     2

col1     col2
1         1
2         1
3         1
4         1
5         1
6         2

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