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 / sreenivasa

SELECT DEPTNO, ENAME, SAL FROM EMP A WHERE 4 = (SELECT COUNT
(B.SAL) FROM EMP B WHERE A.SAL < B.SAL)

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


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

886


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2198


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

1972


What is the use of cognos decision stream?

1035


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

950


What is the difference between static and dynamic conditions?

1015


Can you define set to be cardinality?

949


Why cognos decision stream is used?

1069


What do you mean by Drill down and Drill Up?

934


How can I test reports in cagonos?

903


How can you link a query to a data container manually in Report Studio?

2304


Can you define folder?

911


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2251


what is log in cognos?

1138