Welcome to collectivesolver - Programming & Software Q&A with code examples. A website with trusted programming answers. All programs are tested and work.

Contact: aviboots(AT)netvision.net.il

Buy a domain name - Register cheap domain names from $0.99 - Namecheap

Scalable Hosting That Grows With You

Secure & Reliable Web Hosting, Free Domain, Free SSL, 1-Click WordPress Install, Expert 24/7 Support

Semrush - keyword research tool

Boost your online presence with premium web hosting and servers

Disclosure: My content contains affiliate links.

40,285 questions

52,311 answers

573 users

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 429 views
1 answer 268 views
1 answer 282 views
1 answer 286 views
1 answer 305 views
...