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

5 votes191 views1 answer
Mysql created at yesterdau
SQL
0 vote193 views2 answers
Plsql function that return a table
SQL
0 vote191 views1 answer
Sub blocks in sql
SQL
3 votes207 views1 answer
Postgres count distinct
SQL
0 vote201 views1 answer
Search starting with mysql
SQL
0 vote185 views1 answer
Postgresql regular expression special characters
SQL
2 votes215 views1 answer
Ifnull postgres
SQL
2 votes196 views2 answers
Oracle no data found error code
SQL
1 vote212 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
0 vote245 views2 answers
Insert data into multiple tables mysql
SQL