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

Why we use cross join?

549


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

549


What are the benefits of pl sql?

540


what happens if null values are involved in expressions? : Sql dba

577


How many aggregate functions are available there in sql?

536






What are procedures used for?

541


How do I order columns in sql?

537


what is auto increment? : Sql dba

583


Explain the structure of pl/sql in brief.

628


Can we group by two columns in sql?

515


What is meant by <> in sql?

515


What are the types of join and explain each?

593


How do you concatenate in sql?

561


Why is sharding used?

558


Why is normalization important?

549