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
- 38362 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
Enlist the functions performed by sas.
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
What is run-group processing?
What will calendar procedure do?
Mention what are the data types does SAS contain?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
What are the different servers in sas? : sas-grid-administration
what is the effect of the options statement errors=1? : Sas programming
what type of graphs we will create(for 2+years candidates)?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
What are types of transport files?
What is interleaving in SAS?
Are you involved in writing the inferential analysis plan? Tables specfications?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
what is hash files in sas and why we are using this one in sas?
