How to use SQL MAX() Function in MySQL

2 Answers

0 votes
SELECT MAX(Salary) FROM workers

 



answered Oct 2, 2015 by avibootz
0 votes
SELECT * 
FROM workers 
WHERE Salary < (SELECT MAX(Salary) FROM workers)

 



answered Oct 3, 2015 by avibootz

Related questions

1 answer 371 views
2 answers 446 views
3 answers 401 views
2 answers 389 views
2 answers 372 views
1 answer 326 views
...