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 DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT

Answer Posted / guest

select *from emp where max(sal)=dept;

Is This Answer Correct ?    2 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What the is the diff between local index and global index. give some example.

1638


What is an oracle wallet?

942


query optmization techniques and quwry analyser+projects+ppts

2419


How to work with data objects interactively?

982


Explain the use of indexes option in imp command.

1179


How to see free space of each tablespace?

1034


State some uses of redo log files?

1006


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2232


What is blob datatype?

1126


How to create a new user account in oracle?

1020


Why do we use bulk collect in oracle?

1058


How to use "for" statements in oracle?

1072


Describe varray?

1056


What is the usage of synonyms?

1141


How to store pictures on to the database?

973