SELECT max(MY_COLUMN) FROM my_table; SELECT MY_ID, max(MY_COLUMN) FROM my_table GROUP BY ID; -- Max by MY_ID