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
- 9721 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
How to create id with auto_increment on oracle?
if you ctreate table identity
How to loop through a cursor variable?
ABOUT IDENTITY?
What is a nested table?
What are a cluster and non-cluster index?
what is meant by magic query
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What are the original export and import utilities?
What happens to the current transaction if the session is killed?
Explain alias?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to add another datafile to a tablespace?
How do we represent comments in oracle?
Explain what are clusters?
