How to find second highest salary

Answer Posted / shrikant patil

select max(salary) from tbl_name where salary !=(select
max(salary) from tbl_name);

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are parent constructors called implicitly inside a class constructor?

514


What is the use of array_count_values() in php?

532


Explain how is it possible to cast types in php?

533


Which is true about the singleton design pattern?

551


What is PECL?

775






What function do we use to find length of string, and length of array?

529


Which is best framework for php?

561


Difference between mysql_connect and mysql_pconnect?

506


How to count a number of words in a string in php?

509


What is php programming used for?

500


What are the differences between GET and POST methods in form submitting?

566


How to get no of arguments passed to a PHP Function?

496


What is magic quotes?

601


What is uri routing?

519


What is the difference between fopen() and fclose()?

586