Thursday 26 June 2014

Find the second highest salary from salary table in mysql


Find the second highest salary from salary table in mysql

SELECT max(salary) FROM `employee` WHERE salary < (select max(salary) from employee )

2 comments:

Anonymous said...

Way cool! Some very valid points! I appreciate you writing this
article and the rest of the website is very good.

Stop by my web-site - great home ideas

Anonymous said...

I'm no longer sure the place you're getting your info, but good topic.

I must spend some time learning more or working out more.
Thanks for wonderful info I was on the lookout for
this information for my mission.

Here is my blog - Oxnard