Interested to Buy Any Domain ? << Click Here >> for more details...
i want department wise maxmum salary and empolyee name
- 9 Answers
- 29358 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanjay pradhan
select ename,sal,deptno from emp where (deptno,sal) in
(select deptno,max(sal) from emp group by deptno);
| Is This Answer Correct ? | 15 Yes | 4 No |
Post New Answer View All Answers
What do you know about normalization? Explain in detail?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is rich query?
What is an oracle cursor variable?
What are the attributes that are found in a cursor?
if you ctreate table identity
Explain what are synonyms used for?
What are a collation and state the different types of collation sensitivity?
How would you change old and new values in an insert, delete and update triggers?
What is truncate oracle?
How does the on-delete-cascade statement work?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Design database draw er diagram for a certain scenario ?
What is literal?
