How to get employee name from employee table which is the
fiveth highest salary of the table
Answer Posted / m haribaskar
Select Salary From Employee a Where 5=(
Select Count(Distinct Salary) From Employee b
Where a.Salary <= b.Salary )
| Is This Answer Correct ? | 25 Yes | 7 No |
Post New Answer View All Answers
define sql update statement ? : Sql dba
What is sql resultset?
How does an execution block start and end in pl sql?
What are the types of queries in sql?
What is parallel hint?
What is a trigger in sql?
Can we use join in subquery?
What is the difference between inner join and left join?
What is the difference between cluster and non-cluster index?
Why stored procedure is faster than query?
How do you explain an index?
How can we make an if statement within a select statement?
Are subqueries faster than joins?
What are different clauses used in sql?
How can we debug in PL/SQL?