Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

What are pdv and it functions?

1146


explain the function of substr in sas? : Sas-administrator

1013


Give some examples where proc report’s defaults are different than proc print’s defaults?

1073


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.

1881


how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

1034


Explain the main difference between the sas procedures and functions? : Sas-administrator

1070


Define run-group processing?

1043


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

1064


What was the last computer book you purchased? Why?

2374


Explain substr function?

1111


Explain the special input delimiters used in sas programming.

1008


what is the use of proc contents and proc print in sas? : Sas-administrator

1061


Give e an example of..

2100


: and & modifiers.

1393


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

5451