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 to create a table index in mysql? : Sql dba

591


What is data manipulation language?

696


What are the types of dbms?

545


What is a common use of group by in sql?

590


which tcp/ip port does sql server run on? : Sql dba

515






What is sql analyzer?

537


what is not null constraint? : Sql dba

544


Why is normalization important?

536


What are functions in sql?

507


I need a function for a train ticket reservation please answer it thanks in advance

561


What is the maximum rows in csv?

485


Differentiate pl/sql and sql?

559


how to use like conditions? : Sql dba

573


Explain how can you save or place your msg in a table?

593


What is offset in sql query?

593