count max and return sql code example

Example: sql max count

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