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 to select the name of employee who is getting maximum
sal with out using subquery

Answer Posted / atal patra

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

Is This Answer Correct ?    6 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a new tablespace in oracle?

967


Write a trigger example in oracle?

1031


Explain oracle insert into command?

1087


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2139


How to use "in out" parameter properly?

1033


Describe varray?

1037


What do you know about normalization? Explain in detail?

934


What is the difference between online and offline backups?

1038


What to do if dba lost the system password?

1148


What is a cursor in oracle?

1159


How many anonymous blocks can be defined?

1162


How to start instance with a minimal initialization parameter file?

1024


What is the string concatenation operator in oracle?

1151


What is ADDM Advisor in Oracle?

1158


How to create a new oracle data file?

1019