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 373 views
2 answers 453 views
3 answers 405 views
2 answers 392 views
2 answers 378 views
1 answer 330 views
...