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

what is a Nested Loop join?

2057


What are the advantages of oracle 12c?

1143


What are the varoius components of physical database structure of oracle database?

970


Can we store pictures in the database and if so, how it can be done?

1005


what is port in oracle? how is it related to database application.

1907


What is oracle database client?

994


What is a package in oracle?

1061


Explain the difference between sql and oracle?

1045


How can we force the database to use the user specified rollback segment?

1093


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2278


What is hash cluster in oracle?

1116


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1972


Explain what are the advantages of views?

1031


How to load a large xml file?

1019


Explain an exception?

956