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

select max(sal) from emp where sal<(select max(sal) from emp);

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to drop a stored function?

1137


What are ddl statements in oracle?

1075


master table and child table performances and comparisons in Oracle ?

2138


What is PL/SQL ?

2070


Can we write dml statement in function in oracle?

1082


In which language oracle has been developed?

1075


What are the restrictions in a oracle read only transaction?

1035


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?

1949


How to create tables for odbc connection testing?

1117


How to turn on or off recycle bin for the instance?

1085


Is there a function to split a string in plsql?

1062


what are actual and formal parameters?

1104


Use of an integrity constraint is better to validate data. Explain

1041


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1995


How to lock and unlock a user account in oracle?

1106