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

What is the difference between null value, zero, and blank space?

651


What is an intersect?

751


What is procedure in pl sql?

619


How do I create an index in word?

630


How to use distinct and count in sql query? Explain

695






How do you concatenate in sql?

633


List the various privileges that a user can grant to another user?

677


Which one is better subquery or joins?

668


What is the use of & in pl sql?

619


How do I edit a trigger in sql developer?

626


Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

640


What are all the common sql functions?

651


What are sql objects?

643


What is a delimiter in sas?

644


what are local and global variables and their differences? : Sql dba

624