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 vote125 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote121 views1 answer
Mysql workbench format date
SQL
0 vote128 views3 answers
How to assign custom id in mysql
SQL
0 vote136 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote119 views1 answer
Sql roll up rows into columns
SQL
1 vote125 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
0 vote118 views2 answers
Plsql regex match whole word
SQL
7 votes116 views6 answers
Group_concat mysql
SQL
1 vote127 views1 answer
Sql find column name like
SQL
2 votes124 views1 answer
Copy all values of a column to another column in sql in same table
SQL