Answer Posted / debashis mohanty
Select Name,Deptno,Salary,Rank from
(
Select Ename Name,Deptno,Sal Salary,Rank () over(Order By Sal Desc) Rank from emp
)
Where Rank=4
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can I call a procedure inside a function?
how would you get the current date in mysql? : Sql dba
Why schema is used in sql?
what is the difference between myisam static and myisam dynamic? : Sql dba
What is the difference between a primary key and a clustered index?
What is the best free sql database?
What are sql indexes?
What is varchar example?
What is the primary key?
What is cte?
How do I count records in sql?
what are dynamic queries in t-sql? : Transact sql
Explain the rollback statement?
How do I know if I have sql express or standard?
what is recursive stored procedure? : Sql dba