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
- 21397 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rakesh
select rownum as rank,name,sal
from
( select name,sal from employees order by sal desc)
where
rownum=5
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
Can you define bitmap index?
What is a dimension?
how can you get the errors in job? when loops are araised we get error?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Can you define transformer?
What is the deployment requirements used in cognos?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
difference between impromptu and cognos8
How to Reset Pagenumbers in one report.
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What are the methods by which it non-durable model could be changed into the durable model?
What are the message flows?
What are types of batch available in cognos?
