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

select min(marks) from (SELECT sid FROM(SELECT sid FROM STUDENT ORDER BY SId desc) WHERE ROWNUM <=2);

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of segments in Oracle?

1014


What happens if you use a wrong connect identifier?

983


What is meant by raw datatype?

1006


Why packages are used in oracle?

1004


What is the use of file param in imp command?

1117


What is the usage of synonyms?

1064


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1854


How to connect to the server with user account: sys?

973


What is a snapshot log?

956


What are the advantages of oracle 12c?

1124


How does the on-delete-cascade statement work?

1061


Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

954


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1895


Which environment variables are absolutely critical in order to run the OUI?

2072


What are the different types of partitions in oracle?

911