Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

write a query to find 4th max salary

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


Please Help Members By Posting Answers For Below Questions

Can I call a procedure inside a function?

1003


how would you get the current date in mysql? : Sql dba

965


Why schema is used in sql?

1045


what is the difference between myisam static and myisam dynamic? : Sql dba

1057


What is the difference between a primary key and a clustered index?

982


What is the best free sql database?

1049


What are sql indexes?

992


What is varchar example?

1022


What is the primary key?

947


What is cte?

971


How do I count records in sql?

991


what are dynamic queries in t-sql? : Transact sql

1016


Explain the rollback statement?

1001


How do I know if I have sql express or standard?

1026


what is recursive stored procedure? : Sql dba

981