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
Can you define a datastore in cognos?
What are the batches and it’s details?
What are the themes in a data warehouse?
What is a dimension?
What r the names of the reports that you prepared?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
Can you define folder?
What do you understand by the term 'aggregate advisor?'
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
Define query studio?
2. What functional area you worked on.
What are the types of catalogs in cognos?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
How is possible this scenario using in type-in prompt.?
What is the size of database for you project?