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
- 21400 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
select * from emp e where 5=(select count(distinct sal)
from emp e where e.sal<=sal)
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
Why need staging area database for dwh?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
what is the main advantage of impromptu over cognos reportnet?
Can you define framework manager?
What r the names of the reports that you prepared?
What do you mean by drill across?
Give me any example of semi and non additive measures?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
What do you mean by Drill down and Drill Up?
Explain the difference between powerplay transformer and power play reports?
What is a Query Subject?
Define olap designer?
How create measures and demensions?
What is the difference between low affinity and high affinity connections?
i was asked what are the caluclations done by you in your report? plz give reply
