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

Explain alias in sql?

768

what are the non-standard sql commands supported by 'mysql'? : Sql dba

774

What if we write return in procedure?

972

Explain the purpose of %type and %rowtype data types?

663

What is the non-clustered index in sql?

753

Is t sql a programming language?

761

What is the purpose of primary key?

749

What are views in sql?

721

How many row comparison operators are used while working with a subquery?

754

How does a covering index work?

693

Explain character-manipulation functions?

836

What company owns postgresql?

769

What is sqlexception in java?

732

What is a schema? How is it useful in sql servers?

792

What is java sql drivermanager?

746