Differentiate primary key and partition key?
No Answer is Posted For this Question
Be the First to Post Answer
how can we analyze the locks ?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
What is teradata? What are some primary characteristics of teradata?
What are the primary characteristics of the Teradata.
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
How do you set the session mode parameters in bteq?
How would you load a very large file in teradata in general?
How do you create tables? Exact syntax, and create profiles, users in teradata?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
Syntax for case when statement?
How do you Generate Sequence in Teradata?