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
- 20918 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / balanandam
select * from((select * from emp order by sal desc where rownum<=5)MINUS(select * from emp order by sal desc where rownum<=4))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What is main difference mapplets and mapping?
What is the enterprise class platform architecture of cognos 8?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What is a Framework manager?
what are the names of the reports that you prepared?
What is main advantage datawarehousing over oracle?
What actually a project contains?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
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
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
can we insert all types of charts in a list report? what r the realtime prompts?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
what is the difference between filter and condition?
Can you explain model durability?
