Sql display max value

SELECT MAX(<numeric column>) FROM <table>;
SELECT MAX(<numeric column>) FROM <table> GROUP BY <other column>;

Source: teamtreehouse.com

Sql max value in column

SELECT MAX(salary) FROM employees;
SELECT id, MAX(salary) FROM employees GROUP BY id;

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, max(salary) AS salary FROM employees GROUP BY id
) t2 ON t1.id = t2.id AND t1.salary = t2.salary;

Similar codes

3 votes328 views1 answer
Sql multi column index performance
SQL
0 vote321 views1 answer
T-sql check if data exists
SQL
2 votes336 views1 answer
Set column to not null mysql
SQL
61 votes535 views6 answers
Mysql add column
SQL
2 votes321 views1 answer
Oracle index size calculation
SQL
0 vote362 views1 answer
What is SQL data store?
SQL
0 vote286 views1 answer
Java spring boot connect to sql server
SQL
1 vote363 views2 answers
One to one and one to many relationship
SQL
5 votes358 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
1 vote294 views1 answer
Psql show with user is logged in
SQL