Interested to Buy Any Domain ? << Click Here >> for more details...
we have two tables emp,dept.emp has eno,ename,sal and dept
has deptno,dname.how to find maxsal of each dept wise.which
join used for joining.
- 5 Answers
- 16648 Views
- Accenture, Cognizant, I also Faced
- E-Mail Answers
Answer Posted / subbareddy kake
with out using any Join conditions
Select deptno, max(sal)
from emp group by deptno
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the multiload utility limitations?
What is the difference between fastload and multiload?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are the commands to make a new table, change a table and remove a table in teradata?
What are the string manipulation operators and functions associated with teradata?
What is the difference between teradata and basic rdbms?
What are some commonly used bteq scripts?
Explain fastload in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What happens in a conflict? How do you handle that?
What is the use of teradata system software?
How to identify ppi columns?
What are the functions performed by bynet?
What is primary index and secondary index?
What happens when a node suffers a downfall?
