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 / ahmad nazmi

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

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does rownum mean in sql?

1091


What does cursor do in sql?

1067


What is sql select statement?

1087


Which certification is best for sql?

1041


What is delimiter sql?

1060


What is the best partition size for windows 10?

1049


What do you mean by “trigger” in sql?

1130


What is sql*loader and what is it used for?

1222


How does a covering index work?

1011


how do you login to mysql using unix shell? : Sql dba

1129


Is primary key a clustered index?

1013


what is the difference between where clause and having clause? : Sql dba

1046


Can one improve the performance of sql*loader? : aql loader

1099


Mention what is the plv (pl/vision) package offers?

1163


what are the nonstandard string types? : Sql dba

1208