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 votes168 views1 answer
Purge undo tablespace oracle 11g
SQL
1 vote161 views1 answer
Update from select oracle
SQL
1 vote144 views1 answer
Mysql count all table rows
SQL
0 vote146 views1 answer
Sql datediff db2
SQL
3 votes162 views2 answers
Having in mysql
SQL
0 vote137 views1 answer
Mysql last 6 months
SQL
0 vote146 views1 answer
Sql new line output
SQL
0 vote125 views1 answer
Mysql find foreign key references
SQL
4 votes145 views3 answers
Sql find second highest salary employee
SQL
0 vote145 views1 answer
View t-sql mail configuration
SQL