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

select sal as Max_sal, ename from emp where sal
IN( select max(sal) from emp);






sun_ramprasad@yahoo.com

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why plvtab is considered as the easiest way to access the pl/sql table?

1217


what are all the different normalizations? : Sql dba

1047


What are the features of pl sql?

1068


How to return an array from java to pl/sql?

1144


Which is better stored procedure or query?

958


How will you distinguish a global variable with a local variable in pl/sql?

1156


What is the difference between truncate and drop statements?

1191


Which certification is best for sql?

993


What are the 3 types of behavioral triggers?

1256


Explain commit, rollback and savepoint.

1005


What are views in sql?

994


What sql does db2 use?

984


What type of database is cloud sql?

1105


Explain what is dbms?

1071


What are its different types of dbms?

1008