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

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

Is This Answer Correct ?    0 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we need oracle client?

925


What is pragma autonomous transaction in oracle?

1041


What is the minimum client footprint required to connect c# to an oracle database?

1072


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1966


Where are the settings stored for each instance in oracle?

1094


What are dml statements in oracle?

1075


What is the quickest way to export a table to a flat file?

952


How to get a list of all background sessions in the database?

971


How to rename a tablespace in oracle?

1071


Can I create users through internet explorer in oracle 10g?

1067


What is set verify off in oracle?

1075


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1928


What are the attributes of cursor?

1034


What is a subquery in oracle?

1087


What are the different windows events activated at runtime ?

2881