I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.
Answer Posted / venkat
select * from emp_test where sal IN(select max(sal) from
emp_test group by deptno)
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is the oracle implicit cursor?
What is key preserved table?
Explain oracle’s server parameter file.
How to see the table columns used in an index?
How to define a cusotmer as a supplier in ORACLE R12
What is the difference between formal parameters and actual parameters?
What are the arithmetic operations?
How many categories of data types in oracle?
What is a database table in oracle?
What is format trigger?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Is the After report trigger fired if the report execution fails ?
Does oracle database need java?
How many types of cluster table in Oracle?
What is a user role in oracle?