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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT

Question Posted / guest

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

How to define a procedure inside another procedure?

1024

How to create a table interactively?

1093

How many anonymous blocks can be defined?

1184

What is a sub query? What are its various types?

1179

How to change user password in oracle?

1029

What happens if recursive calls get out of control?

1082

How to sort output in descending order in oracle?

1045

How to connect to the server with user account: sys?

1022

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1990

1) Does oracle have any table which contain all the exceptions and it's code internally?

1749

WHAT IS ecc 6.0

2147

Can a formula column be obtained through a select statement ?

2327

What is procedure overloading in oracle?

1061

What is a data lock in oracle?

1122

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1929