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 are the various indexes in teradata? How to use them?
What is meant by Teradata Gateway?
Difference between Qualify and group
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
What is meant by a Highest Cost Plan?
Fast Load Script is failed and error tables are available then how do you restart?
how do you handle ET and UV errors ?
If table have access lock.In the same table write lock is posible or not?
What are the available join types in teradata?