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...

Query for second maximum salary in each in each department

Answer Posted / yaswanth

select salary from(select salary,rownum rk from(select salary from employees order by salary desc)) ehere rk=2;

Is This Answer Correct ?    2 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does bitemporal mean?

1117


Which are the different character-manipulation functions in sql?

1113


How to run sql statements through the web interface?

1097


Does sql use python?

1095


What is mutating sql table?

1160


Does sql between include endpoints?

1063


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1214


What is the starting oracle error number? What is meant by forward declaration in functions?

1045


Is sql easier than java?

1069


What is range partitioning?

1017


What is a sql schema used for?

1158


how to convert numeric values to character strings? : Sql dba

1162


What if we write return in procedure?

1517


Can we call procedure in select statement?

1113


what is the different between now() and current_date()? : Sql dba

1077