SELECT first_name, salary FROM employees E1 WHERE (3)

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

Question Posted / ajeet

Answer Posted / ajeet

SELECT first_name, salary FROM employees E1
WHERE (3) > (SELECT COUNT(DISTINCT(E2.salary))
FROM employees E2
WHERE E1.salary > E2.salary)

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Which is faster joins or subqueries?

555

What is indexes?

545

What are tables in sql?

550

does sql support programming? : Sql dba

611

What are sql commands?

505

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

539

what is a database lock ? : Sql dba

594

What are types of joins?

538

how to check myisam tables for errors? : Sql dba

607

Explain the difference between triggers and constraints?

521

Name the operator which is used in the query for pattern matching?

506

how many columns can be used for creating index? : Sql dba

523

Can we commit in trigger?

549

What is the difference between row level and statement level trigger?

522

Explain the steps needed to create the scheduled job?

565