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 / selvaraj v , anna university c

select ename, salary from emp where salary=(select max
(salary) from emp) order by emp_no;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between procedure and trigger?

1022


What are the popular database management systems in the it industry?

1038


Why is stored procedure faster than query?

1023


How do I find sql profiler?

992


What is field delimiter?

1114


How do you use a while loop in pl sql?

1056


What are conditional predicates?

1128


What are pl/sql cursors?

1104


What is benefit of creating memory optimized table?

1034


Can we create table inside stored procedure?

1016


How does one use sql*loader to load images, sound clips and documents? : aql loader

1236


What is the difference between union and union all command?

1151


How does cross join work in sql?

1079


What do you mean by “trigger” in sql?

1130


Can we use threading in pl/sql?

1099