Find out the 3rd highest salary?

Answer Posted / sathiskumar

select min(sal) from (select top 3 salary from employee);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use partitions in sql?

547


What is set serveroutput on?

642


Determine if oracle date is on a weekend?

556


Explain cursor types?

581


what is union? : Sql dba

582






what are the types of subquery? : Sql dba

590


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

548


how are mysql timestamps seen to a user? : Sql dba

564


Is trigger a stored procedure?

506


What is group function in sql?

538


What is mdb stand for?

556


What are different types of sql?

564


How we can update the view?

601


what is error ora-03113: end-of-file on communication channel?

603


discuss about myisam key cache. : Sql dba

563