I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.
Answer Posted / sunil
select depid,max(sal) from <table name> group by depid;
Is This Answer Correct ? | 33 Yes | 4 No |
Post New Answer View All Answers
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Explain what are the uses of rollback segment?
what is the difference between substr and instr function in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to create a table index in oracle?
What is system global area (sga) in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Explain about integrity constraint?
How does one get the view definition of fixed views/tables?
How to start an oracle instance?
What privilege is needed for a user to delete rows from tables in another schema?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What happens if you lost a data file?
Explain rename?
How do you bind variables in oracle?