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
- 37502 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
how can you import .csv file in to sas? : Sas programming
how do you pull data from equifax?tell me the process?
: and & modifiers.
Describe crosslist option in tables statement?
Name few SAS functions?
what other sas products have you used and consider yourself proficient in using? : Sas programming
which features do you use to check the data validations and errors? : Sas-administrator
How many ways to overcome a missing values???
If money were no object, what would you like to do?
Describe the ways in which you can create macro variables? : sas-macro
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
How do you specify the number of iterations and specific condition within a single do loop?
How to read an input file in sas?
Name any two sas spawners? : sas-grid-administration
How do you debug and test your SAS programs?
