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
- 14143 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
What is a three-tier data warehouse?
What do you mean by teradata sql assistant?
What is node? How many nodes and amps used in your previous project?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is meant by a Parsing Engine?
What are teradata utilities?
Explain some differences between mpp and smp?
What are the functions performed by bynet?
Explain amp in teradata?
how do you manage the production space. what are the proactive methods you can take ?
How to run a query in teradata?
Highlight a few of the important components of Teradata?
How would you load a very large file in teradata in general?
What is the use of teradata system software?
