Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13996 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
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is the use of virtual processor connectivity in teradata?
Explain and compare pros and cons of snow flake schemas?
What are the components provided on node?
Highlight the differences between Primary Key and Primary Index.
Different phases of multiload?
Explain vproc in teradata?
Highlight a few of the important components of Teradata?
Where is teradata rdbms used?
How do you determine the number of sessions?
What is the difference between fastload and multiload? Which one is faster?
Can you fastexport a field, which is primary key by putting equality on that key?
How to load specific no.of records using bteq, or fastload,or multiload
What do you mean by tpt in teradata?
Why managing the data is important?
