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
- 14010 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / gayathri
Sel Empname,deptid, (qualify row_number() over (partition by deptid order by sal asec)=1) as min_sal, (qualify row_number() over (partition by deptid order by sal desc)=1) as max_sal from EMP
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a three-tier data warehouse?
What are the advantages of teradata?
What are the enhanced features in teradata v2r5 and v2r6?
What is oltp?
List out all forms of LOCKS that are available in Teradata.
How to load specific no.of records using bteq, or fastload,or multiload
What is a dimension table?
How many codd's rules are satisfied by teradata database?
What is TPD?
What are the uses of client software involved in teradata?
Explain teradata architecture?
What are the updated features of teradata?
What are the different functions included in the server software?
If RDBMS is halted what will you do ?
how many modules are there in telecome domain?how to explain the architecture?
