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 CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

Answer Posted / chandu

select ename,sal from emp where sal=(select max(sal) from emp);

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql clause?

992


What are the parameter modes supported by pl/sql?

1019


How to use boolean type in select statement?

994


what is 'mysqlcheck'? : Sql dba

959


How do I view an execution plan in sql?

922


Why commit is not used in triggers?

992


What steps server process has to take to execute an update statement?

920


Is primary key an index?

945


What is partition by in sql?

1000


explain the delete statements in sql

977


Why is there a need for sqlcode and sqlerrm variables?

996


what is union? : Sql dba

965


Explain the difference in execution of triggers and stored procedures?

966


What is the process of debugging?

1001


What is the difference between the sql*loader and import utilities? : aql loader

976