Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17533 Views
- HCL, I also Faced
- E-Mail Answers
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
What is a Folder?
Can you define framework manager?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What is main difference mapplets and mapping?
Explain difference between powerplay transformer and power play reports?
Explain the difference between powerplay transformer and power play reports?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
how u will design the report if the objects are available
write a query to display the departments with no employee?
Define cognos report net?
Can you explain the advantage of using shortcuts?
tell me two or three issues from client side and how to solve those issues?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What is difference between informatica power mart and power center?
what is power prompt in cognos ep7series?what is the use of this?
