Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary from a employee table and
how get a 5th highest salary from a employee table?
- 11 Answers
- 37976 Views
- ABC, Amex, I also Faced
- E-Mail Answers
Answer Posted / dinesh
select * from emp e where
2 =(select count(distinct sal) from emp where e.sal<=sal)
or 5=(select count(distinct sal) from emp where e.sal<=sal);
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
Give an example where SAS fails to convert character value to numeric value automatically?
What is the difference between nodupkey and nodup options?
How we can create SAS USER DEFINED CODE?
how do you test for missing values? : Sas programming
explain the concepts and capabilities of business object? : Sas-bi
what is business intelligence? : Sas-bi
What are the 3 components in sas programming?
How would you include common or reuse to be processed along with your statements?
Explain translate function?
How do you control the number of observations and/or variables read or written?
How sas treats the dsd delimiters?
what is treatment emergent events and treatment emregent adverse event
Describe a time when you were really stuck on a problem and how you solved it?
Give some examples where proc report’s defaults are same as proc print’s defaults?
what is sas olap server? : Sas-di
