How to find all the max values of a field in MySQL table with SQL

1 Answer

0 votes
SELECT salary FROM salaries WHERE salary = (SELECT Max(salary) FROM salaries)

-- salary
-- ------
-- 10000
-- 12000
-- 13000
-- 13000
-- 10000
-- 11000

-- result:

-- salary 	
-- ------
-- 13000
-- 13000

 



answered Sep 11, 2016 by avibootz

Related questions

2 answers 461 views
1 answer 298 views
1 answer 317 views
1 answer 321 views
1 answer 345 views
...