find the third highest salary?

Answer Posted / kiran

select salary from employees e where 3 = (select count
(distinct salary) from employees f where
e.salary <= f.salary);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I debug a stored procedure?

811


what is primary key? : Sql dba

710


What will you get by the cursor attribute sql%notfound?

777


how to use case expression? : Sql dba

733


What are the sql commands?

792






Does sql profiler affect performance?

733


What is record data type?

677


What is output spooling in sql*plus?

741


What is sql profiler in oracle?

759


How to fetch alternate records from a table?

865


Why do we create views in sql?

778


Mention what does the hierarchical profiler does?

733


Explain what is sql*plus?

855


What is sql select statement?

703


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

840