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
- 13799 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 meant by a Clique?
Mention a few of the ETL tools that come under Teradata.
What is teradata? Also, list out some of the primary characteristics of teradata.
What is meant by a Channel Driver?
Difference between inner join and outer join?
How to view every column and the columns contained in indexes in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the different table types supported by teradata?
Explain the teradata primary index mechanics in detail with a diagram.
Explain amp in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Highlight the limitations of TPUMP Utility.
Syntax for case when statement?
What are the components used in smp and massively parallel processing (mpp) machines?
When tpump is used instead of multiload?
