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
What is set transaction?
What view means?
what are the join types in tsql? : Transact sql
What do you think about pl/sql?
What is nested table in pl sql?
How do you declare a variable in pl sql?
Can we use joins in subquery?
How many types of triggers are there in pl sql?
What are the most important ddl statements in sql?
Which is faster view or stored procedure?
How do I find duplicates in a single column in sql?
what are properties of a transaction? : Sql dba
What is sql architecture?
How do I install sql?
Define the select into statement.