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
- 21411 Views
- HCL, I also Faced
- E-Mail Answers
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
What you mean by drill across and what is the difference between drill through, drill across?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
how u will determine the performence tune will occur either in report or system
What is the function of model design accelerator?
i have one file i saved in csv how can i take these file into framework manager
What do you mean by Drill down and Drill Up?
Can you define materialized view?
What is the difference between ‘macro’ and ‘prompt?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
How can create users and permissions in cognos?
is there any difference between operational database and data base?if yes what r they?
Can you define dimension?
Which studio is used to create reports?
-------------How you design DWH?
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
