in ur table contains the coloumns like deptno,sal empname
then i want output as
deptno subtotalofdept totalsal
10 3700 3700
20 3400 7100
like that
What is inner join and outer join?
Why teradata is used?
Explain some differences between mpp and smp?
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.
what is referential constraints?how do you implement RI in teradata?
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
Fast Load Script is failed and error tables are available then how do you restart?
What can be achieved by using the teradata rdbms?
Can any one please provide me practical example of How to do the performance tuning in Query??
What is the use of fallback?
If table have access lock.In the same table write lock is posible or not?
What tools would you use for that?