find the third highest salary?

Answer Posted / noorulahaq

select min(sal) from emp where sal in (
select sal from
( select sal from emp order by sal desc )
where rownum <=3 )

Is This Answer Correct ?    26 Yes 17 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?

762


What are the different sql commands?

722


What is a variable in sql?

720


What is cursor in pl sql with examples?

672


What is primary key and foreign key?

716






What is auto increment?

733


How do you define a foreign key?

718


What is snowflake sql?

799


What is identity column in sql server?

718


What is a crud api?

684


how many ways we can we find the current date using mysql? : Sql dba

810


Can we use commit inside a trigger?

763


what are the authentication modes in sql server? How can it be changed? : Sql dba

954


What is a native sql query?

701


What does sign mean sql?

759