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 SQL query which should fetch the 5th maximum salary
of an employee from the table?

Answer Posted / dramesh511

select sal from emp e where 5=(select count(sal) from
emp e1 where e.sal<=e1.sal)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is hints in cognos and where we use it.

2455


what are the errors faced while bursting the reports and how to solve those errors?

2021


is cognos 7 is better than cognos 8

2165


Define catalog in cognos and write its various types?

1183


What are all the types of indexes in Cognos?

1238


Explain difference between powerplay transformer and power play reports?

956


What do you mean by Drill down and Drill Up?

998


What are all the types of hierarchies?

1139


what are the dimensions that you have in your current project?list them?

2024


What are all the different types of prompt in cognos?

1051


Define the cognos reporting tool?

1044


What do you understand by the term 'model durability'?

1015


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3305


What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

949


hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

2370