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 / soni

select MIN(salary) from (select distinct salary from employees
order by salary desc) where ROWNUM < 6 ;

ITS SELECTING from employees table 5th highest salary

Is This Answer Correct ?    3 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Multivalued dependency?

790


What is SDL (Storage Definition Language)?

803


What is Weak Entity set?

787


What is System R? What are its two major subsystems?

816


Name the sub-systems of a RDBMS?

823


What are page splits? : sql server architect

907


What is a checkpoint and When does it occur?

778


What is extension and intension?

907


What is 3NF?

872


Does storing of data in stored procedures increase the access time? Explain?

1119


What are pages and extents? : sql server architect

826


What is system catalog or catalog relation? How is better known as?

848


When is a functional dependency F said to be minimal?

784


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?

1538


What is an Entity?

855