Interested to Buy Any Domain ? << Click Here >> for more details...
How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 30061 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / ajeet
SELECT first_name, salary FROM employees E1
WHERE (5) = (SELECT COUNT(DISTINCT(E2.salary))
FROM employees E2
WHERE E1.salary < E2.salary)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how is myisam table stored? : Sql dba
Is and as keyword in pl sql?
What is sql mysql pl sql oracle?
What is string join?
What is use of package in pl sql?
What is the use of double ampersand (&&) in sql queries? Give an example
How do you create a db file?
How to write a query to show the details of a student from students table whose
Inline the values in PL/SQL, what does it mean.?
What is the size of partition table?
how would you enter characters as hex numbers? : Sql dba
how do you know if your mysql server is alive? : Sql dba
Which are the different types of indexes in sql?
Is time a data type in sql?
What is date functions?
