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
- 38361 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 do you pull data from equifax?tell me the process?
How are numeric and character missing values represented internally?
What are the ways in which macro variables can be created in sas programming?
Why and when do you use proc sql?
do you need to know if there are any missing values? : Sas programming
What is the purpose of _character_ and _numeric_?
This entry was posted in General. Bookmark the permalink. Post a comment or leave
Difference between informat and format?
Describe the function and untility of the most difficult SAS macro that you have written.
What sas features do you use to check errors and data validation?
what are sas/access and sas/connect? : Sas programming
What are common programming errors committed in sas
how does sas handle missing values in assignment statements? : Sas programming
What are the data types in sas?
Compare sas with other data analytics tools.
