I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.
- 5 Answers
- 10146 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
What is oracle latest version?
How to select all columns of all rows from a table in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to write a left outer join with the where clause in oracle?
How to use values from other tables in update statements using oracle?
How to start an oracle instance?
Design database draw er diagram for a certain scenario ?
How to put more than 1000 values into an oracle in clause?
