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

find out the second highest salary?

Answer Posted / nagaraju

SELECT LEVEL,MAX(SAL)
FROM EMP
WHERE LEVEL IN(2,3)
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle database client?

1037


What are the differences between blob and clob in oracle?

1090


What is oracle used for?

1029


How would you go about verifying the network name that the local_listener is currently using?

2050


Explain joins in oracle?

1041


What is a cursor in oracle?

1182


What is a sub query and what are the different types of subqueries?

1129


What is oracle data type?

973


How to create a new tablespace in oracle?

991


Is postgres faster than oracle?

1046


How to view existing locks on the database?

1057


How do you bind variables in oracle?

985


What privilege is needed for a user to insert rows to tables in another schema?

1015


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1740


Why use resource manager in Oracle?

1110