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

How do you delete a table?

1081


how can we know the count/number of elements of an array? : Sql dba

1063


What sql does db2 use?

983


Why triggers are used?

993


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1071


What is a database trigger?

1072


What are all the different normalizations?

1036


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

975


How do I know if I have sql express or standard?

1035


What is meant by truncate in sql?

1068


What is trigger in pl sql with examples?

1048


What is view? Can we update view

1442


What is sql key?

998


What is difference between table and view?

1063


how to fetch common records from two tables? : Sql dba

1176