I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.
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
Why we use bulk collect in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Explain a private synonyms?
What are transaction isolation levels supported by oracle?
Design database draw er diagram for a certain scenario ?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What are the uses of a database trigger?
Query to retrieve record for a many to many relationship ?
How would you go about verifying the network name that the local_listener is currently using?
Briefly explain what is literal? Give an example where it can be used?
What is null value in oracle?
what is meant by magic query
How do I know if oracle is installed on windows?
What are the extensions used by oracle reports?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?