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
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How to drop a stored procedure in oracle?
How to define an oracle sub procedure?
How to add another datafile to a tablespace?
How to change system global area (sga) in oracle?
What are the various constraints used in oracle?
What is a sub query and what are the different types of subqueries?
What do database buffers contain?
What happens if recursive calls get out of control?
What is Reduced List of Values?
How would you go about verifying the network name that the local_listener is currently using?
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?
Design database draw er diagram for a certain scenario ?
What is oracle latest version?
How to define a specific record type?