Interested to Buy Any Domain ? << Click Here >> for more details...
I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.
- 5 Answers
- 9994 Views
- Microsoft, Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / vengalrao
Dear Friends,
Depends upon table u can pick one max value is possible,one
table u cannot pick max value of all columans , then u can
refer one any ne column
select depid,max(sal) from <table name> group by depid;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Give the various exception types.
What is the relation of a user account and a schema?
How to create a stored program unit?
how to handle exceptions in post production
What is the difference between pre-select and pre-query?
How to retrieve values from data fields in record variables?
How to bring a tablespace online?
What is format trigger?
How can we find out the duplicate values in an oracle table?
How many categories of data types?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is bulk collect in oracle?
State the difference between a primary key and foreign key?
Explain compound trigger in oracle?
How to use subqueries with the in operator using oracle?
