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 / pradeep nagireddy

select *
from(select rownum r,sal from emp order by sal desc)
where rownum = 5;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2325


how to merge 2 crosstabs thans

2587


Can you define materialized view?

989


how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

1000


Please explain the different stages in creating a report in cognos report net?

956


How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1876


What are the components of report net?

1191


Define datastores in cognos?

888


Can you define framework manager?

970


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

908


What is zero-foot print?

961


What do you mean by drill through report?

920


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

964


Give me any example of semi and non additive measures?

902


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2703