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 find the fifth highest salary?

Answer Posted / nagireddy karri

select min(emp_sal) from (select (Emp_sal) from(select
Emp_sal from emp order by emp_sal desc) and rownum<=5)

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Set-at-a-time or Set-oriented?

932


What is difference between two tier and three tier?

895


Name the buffer in which all the commands that are typed in are stored

850


How is the data structure of System R different from the relational structure?

886


How many types of stored procedure?

896


What is one tier architecture?

818


Not only RDBMS takes care of locating data it also

839


What is the Disadvantage in File Processing System?

883


What is msdb database? : sql server architect

1015


Which part of the RDBMS takes care of the data dictionary? How

1059


What is a query?

919


What is Data Model?

1052


in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1574


What is RDBMS KERNEL?

1126


What is "transparent DBMS"?

907