how to find 2nd highest salary in random database salary of employer.....

Answer Posted / arnab das

select distinct column_name from table_name order by
column_name desc limit 1,1

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the command line end user interface - mysql?

774


Is mysql written in c?

685


How many sql ddl commands are supported by 'mysql'?

836


How many rows can mysql handle?

730


What is the use of procedure in mysql?

710


How triggers can be used in mysql?

779


What is row level locking?

706


How to include character strings in sql statements?

676


Is mysql from oracle?

733


What tools available for managing mysql server?

747


Why do we use the mysql database server?

768


What is the use of mysqli_fetch_array?

739


What is the purpose of using timestamp data type?

713


How to create a test table in your mysql server?

764


What port is mysql running on?

706