how to get second highest salary from a employee table and
how get a 5th highest salary from a employee table?
Answer Posted / beneet kumar pandey
/*second highest salary*/
first select max sal from employee table then select second
max sal from employee table.
Select max(salary) less then(select max(salary) from
employee) from employee;
/*same condition for fifth highest salary*/
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
What are pdv and it functions?
explain the function of substr in sas? : Sas-administrator
Give some examples where proc report’s defaults are different than proc print’s defaults?
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.
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
Explain the main difference between the sas procedures and functions? : Sas-administrator
Define run-group processing?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
What was the last computer book you purchased? Why?
Explain substr function?
Explain the special input delimiters used in sas programming.
what is the use of proc contents and proc print in sas? : Sas-administrator
Give e an example of..
: and & modifiers.
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana