How to find second highest salary

Answer Posted / petercoloney

select salary from employee where max(salary)<(select salary from employee)

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does session start do in php?

507


Tell me whether it is possible to share a single instance of a memcache between multiple php projects?

537


What sized websites have you worked on in the past?

533


What exactly is validating and sanitizing?

617


How do I find out the number of parameters passed into function9?

538






Are php sessions secure?

529


How can we change the value of a constant?

537


What is php array function?

539


is that "enumerated array" equal to "numeric array"?

2022


How do I end a php session?

503


Write a program to get lcm of two numbers using php?

506


How can you create a session in php?

527


How to specify argument default values?

543


What are the 3 types of sessions?

541


Whether it is possible to share a single instance of a memcache between multiple php projects?

530