Find out the 3rd highest salary?

Answer Posted / sachin saini

select min(salary) from table_name where salary in(select
top 3 salary from table_name order by salary desc )

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

620


What is the difference among union, minus and intersect?

546


what are all the different types of indexes? : Sql dba

532


How do I run a sql query?

532


What is data modelling in sql?

523






What are the query optimization techniques?

535


how to start mysql server? : Sql dba

615


what is the difference between join and union? : Sql dba

548


What version is sql?

553


What is the sql query to display the current date?

551


What is the purpose of a secondary key?

513


What is row_number () in sql?

548


What are all the different types of indexes?

625


What is pls integer?

585


What is on delete set null?

570