Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / dramesh511
select sal from emp e where 5=(select count(sal) from
emp e1 where e.sal<=e1.sal)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is hints in cognos and where we use it.
what are the errors faced while bursting the reports and how to solve those errors?
is cognos 7 is better than cognos 8
Define catalog in cognos and write its various types?
What are all the types of indexes in Cognos?
Explain difference between powerplay transformer and power play reports?
What do you mean by Drill down and Drill Up?
What are all the types of hierarchies?
what are the dimensions that you have in your current project?list them?
What are all the different types of prompt in cognos?
Define the cognos reporting tool?
What do you understand by the term 'model durability'?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file