Select Name,Deptno,Salary,Rank from ( Select Ename Name,Deptno,Sal Salary

write a query to find 4th max salary

Question Posted / debashis mohanty

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

Please Help Members By Posting Answers For Below Questions

Can we delete column in sql?

1108

Which are the different types of indexes in sql?

1067

Is a table valued function object?

1027

What is view explain with example?

938

What types of commands can be executed in sql*plus?

1116

how to drop an existing table in mysql? : Sql dba

1053

Can we alter stored procedure?

997

What is the difference between a procedure and a function?

1126

How many types of keys are there in sql?

1044

Are null values same as that of zero or a blank space?

1038

Is left join same as join?

1002

What do you mean by stored procedures?

1022

What is the difference between pl and sql?

1101

Is primary key an index?

1000

Is pl sql a scripting language?

1038