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
- 12732 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 interface is used to connect to windows based applications?
What are some commonly used bteq scripts?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
How do you define Teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
How would you load a very large file in teradata in general?
In Teradata, what is the significance of UPSERT command?
Why does varchar occupy 2 extra bytes?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is upsert statement in teradata?
Explain the term 'database' related to relational database management system?
How do you see a ddl for an existing table?
Why is the case expression used in teradata?
How to find duplicates in a table?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
