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 / pramod janjirala

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

Is This Answer Correct ?    13 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1127


What is before trigger?

1051


What is difference between rank () row_number () and dense_rank () in sql?

1163


What is trigger and types?

1071


what is denormalization. : Sql dba

1162


Explian rowid, rownum?

1086


What is procedure and function in sql?

1045


What are pl/sql cursor exceptions?

1168


How can you select unique records from a table?

1149


How delete all data from table in sql?

1077


How sql query is executed?

1187


What is a unique key and primary key and foreign key?

1022


How do I view a procedure in sql?

1019


Define a temp table?

1082


How to rename a column in the output of sql query?

1131