Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and work.

aviboots(AT)netvision.net.il

Instant Grammar Checker - Correct all grammar errors and enhance your writing
BlueHost Web Hosting

Bonsai Boy of New York Bonsai Trees and Accessories

Website Domains Names & Hosting | Domain.com

Instant Grammar Checker - Correct all grammar errors and enhance your writing

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

DreamHost Web Hosting


Liquid Web Cloud VPS Hosting

Disclosure We are a professional Programming & Software Q&A website, that receives compensation from some of the links whose we show you with Information. It means that my content may contain affiliate links.

13,237 questions

18,022 answers

573 users

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

2 Answers

0 votes
SELECT salary FROM salaries order by salary DESC limit 1 

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

-- result:

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

 




answered Sep 11, 2016 by avibootz
0 votes
SELECT Max(salary) FROM salaries

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

-- result:

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


 




answered Sep 11, 2016 by avibootz
...