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
- 20889 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prashant
SELECT min(salary)
from emp
where salary in (select distinct top 5 salary from emp
order by salary desc)
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / vsandhyana
select top 1 * from (select top 5 * from customers order by
salary desc) a order by salary asc
Thanks
Vikram Sandhyana
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / rakesh
select rownum as rank,name,sal
from
( select name,sal from employees order by sal desc)
where
rownum=5
| Is This Answer Correct ? | 3 Yes | 7 No |
Answer / 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 |
how u provide security in power play transformer???
3 Answers iFlex, ITC Infotech, TCS,
1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?
suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???
what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)
how you provide security to reports? How you provide security to packages ?
Explain the characteristics of cognos?
What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?
How to test reports in cagonos ?
10 Answers CST, CTS,
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
How you create IQD In ReportNet FrameWork?
--------------Explain Table of contents?
What is difference between informatica power mart and power center?
Teradata 
