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
- 29450 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What does 0 mean in sql?
What are the advantages of sql? Explain
Explain the rollback statement?
how to analyze tables with 'mysqlcheck'? : Sql dba
How does a self join work?
What is rownum and rowid?
What is graph sql?
What is the sql*loader? : aql loader
Describe types of sql statements?
how to see the create table statement of an existing table? : Sql dba
What is the source code of a program?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Why use subqueries instead of joins?
Why trigger is used in sql?
What are the sql aggregate functions?
