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
- 9544 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 join syntax?
How to retrieve values from data fields in record variables?
How to start a new transaction in oracle?
How to bring a tablespace online?
How to view the tablespaces in the current database?
What is the disadvantage of User defind function?
State any two functions of oracle?
How to build data dictionary view an new database?
What is meant by a deadlock situation?
What is connection pooling in oracle?
How to use subqueries in the from clause in oracle?
What are the different types of failures that occur in Oracle database?
Explain drop constraint oracle?
What privilege is needed for a user to insert rows to tables in another schema?
How to write an inner join with the where clause in oracle?
