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

4 votes352 views2 answers
Linq join
SQL
0 vote386 views2 answers
List all constraints in postgres
SQL
10 votes322 views2 answers
Django mysql
SQL
0 vote329 views1 answer
Oracle select invalid views
SQL
3 votes366 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote337 views1 answer
Mysql installer no packages found
SQL
0 vote345 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
1 vote379 views1 answer
Sql server delete top 1000
SQL
0 vote356 views1 answer
Get date ISO in psql
SQL
0 vote345 views1 answer
MySQL get all previous date record
SQL