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

Disply the dname wise maximum salary

Answer Posted / divya

SELECT d.dname,max(e.sal) from emp e,dept d where e.deptno=d.deptno
group by d.dname

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

983


What are the data types present in bo? What happens if we implement view in the designer n report?

935


For faster process, what we will do with the universe?

992


a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

2471


What is metadata in context of a datawarehouse and how it is important?

1051


What are the other names given to data warehousing?

1098


How to allow a dynamic selection of a column for a measure in a chart,without using variable?

997


What is is a star schema?

1175


List any five applications of data warehouse.

940


What is a linked cube?

1010


What is partitioning? What are the types of partitioning?

1171


How to pivot row data using informatica?

965


Explain if a flat file cotains 1000 records how can I get first and last records only?

933


How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

953


What are the difference between snow flake and star schema?

1006