select firt_name, salary from employees a where 5=(select count(distinct

How to get employee name from employee table which is the
fiveth highest salary of the table

Question Posted / raju t.t

Answer Posted / raju t.t

select firt_name, salary from employees a where 5=(select
count(distinct salary from employees b where a.salary
<=b.salary);

Is This Answer Correct ?

6 Yes

7 No

Please Help Members By Posting Answers For Below Questions

How much does a sql dba make? : SQL DBA

989

what is sql? : Sql dba

1071

How do you write a complex sql query?

1142

Which one is better subquery or joins?

1115

What is an invalid partition table?

1066

What are pl sql data types?

1056

how to load data files into tables with 'mysqlimport'? : Sql dba

1147

How do I enable sql encryption?

1072

Is pl sql a scripting language?

1082

what is index? : Sql dba

1044

What is data manipulation language?

1233

Is stored procedure faster than query?

1020

How do I order by ascending in sql?

1079

how to calculate the difference between two dates? : Sql dba

1115

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2062