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

0 vote350 views1 answer
Sql query tags
SQL
1 vote347 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
4 votes361 views1 answer
Data types in sql
SQL
4 votes337 views3 answers
Create database in mySQL
SQL
0 vote343 views1 answer
Sql count null values in all columns
SQL
6 votes333 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote348 views1 answer
Import sql in postgresql
SQL
1 vote330 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote407 views1 answer
ALV GRID events
SQL
0 vote279 views1 answer
How to connect sql server using ip address in c#
SQL