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?
- 14 Answers
- 20565 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / dhanu
SELECT DISTINCT SAL FROM EMP E WHERE 5>=(SELECT COUNT(DISTINCT SAL) FROM EMP A WHERE A.SAL<=E.SAL)ORDER BY SAL DESC
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the dimensions that you have in your current project?list them?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
Define catalog in cognos and write its various types?
what are the filters in framework manager and report studio?
2. What functional area you worked on.
How to Reset Pagenumbers in one report.
Explain the difference between native sql and cognos sql?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
What is main difference mapplets and mapping?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
Can you define framework manager?
What is a Pivot?
What is meant by junk dimension?
Can you define a catalog and types of catalogs in cognos?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
