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
- 37508 Views
- ABC, Amex, I also Faced
- E-Mail Answers
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
How would you invoke a macro? : sas-macro
What does the trace option do?
explain what is factor analysis? : Sas-administrator
which date functions advances a date time or date/time value by a given interval? : Sas programming
Name some categories in sas 9? : sas-grid-administration
Name types of category in which SAS Informats are placed?
Explain bmdp procedure?
Which function is used to count the number of intervals between two sas dates?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
How does the internal authentication work in sas? : sas-grid-administration
which features do you use to check the data validations and errors? : Sas-administrator
If a variable contains letters or special characters, can it be numeric data type?
What is the basic structure of the SAS base program?
What does the RUN statement do?
What are the special input delimiters used in SAS?
