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 384 views
1 answer 225 views
1 answer 251 views
1 answer 250 views
1 answer 272 views
...