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

1 vote181 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote298 views1 answer
Oracle sql alter view add column
SQL
1 vote176 views2 answers
Insert sqlite
SQL
0 vote173 views1 answer
Sql common columns
SQL
3 votes190 views2 answers
Mysql select database
SQL
0 vote171 views1 answer
Criteria builder select subset of column
SQL
0 vote167 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote169 views1 answer
Pl sql turn off variable substitution
SQL
3 votes170 views1 answer
Oracle undo tablespace list by user
SQL
0 vote273 views1 answer
Sqlite woth cmake
SQL