I have a employee table with EMPID, EMPNAME, DEPTID, SAL
and want to fetch the maximum and minimum salary on each
dept id with the emp name. Can anyone help in this? The
result should contain the EMPNAME, DEPTID, SAL.
- 4 Answers
- 12384 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / syamal rao
You can try the bellow query in BTEQ of TERADATA.
select empname from employee with max(sal),min(sal) by deptid;
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
Which is faster fastload or multiload?
Explain and compare pros and cons of snow flake schemas?
What is meant by a Virtual Disk?
Why does varchar occupy 2 extra bytes?
What is inner join and outer join?
What is the use of teradata system software?
What do you mean by fastexport in teradata?
How to identify ppi columns?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What tools would you use for that?
Why managing the data is important?
What are the various reporting tools in the market?
What do high confidence, low confidence and no confidence mean in explain plan?
What are aggregate tables? How do you design them using teradata?
Explain PDE.
