SELECT DISTINCT col1, col2, .... FROM table_name; SELECT col1, MIN(col2) FROM table_name GROUP BY col1;