Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update
5 12467In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
3 14603sel 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?
3 8603i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
12 13561Post New CTS Teradata Interview Questions
What are the types of functions in sql?
What is the difference between c and python?
Explain how you can produce execution debug output or error messages?
What is args c#?
What process executed the request?
Why dynamic binding is used in object-oriented programming?
What are xml indexes?
What are the disadvantages of artificial neural networks?
What is struct c++?
What is import in angular?
Explain what is google penguin?
Define Thrift?
Define open loop control system.
When can one deviate from any flight rules and regulations?
Is INSTEAD OF trigger directly applicable to Table ?