How to get employee name from employee table which is the
fiveth highest salary of the table
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 is the purpose of primary key?
Why we use join in sql?
what is a join? : Sql dba
What is the requirement of self-join?
How do I write a sql query in pgadmin 4?
Can we use having without group by in sql?
What is a .db file?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What are the types of subqueries?
What are % type and % rowtype?
How do I view output in sql developer?
What is a Mapplet?
What is a temporal data type?
what is the difference between where clause and having clause? : Sql dba
What is the command used to fetch the first 5 characters of a string?