Which is more efficient group by or distinct to find duplicates?

Question Posted / amarjit kumar

No Answer is Posted For this Question
Be the First to Post Answer

More Teradata Interview Questions

What is multi insert?

How to copy 1 million records from one DB to another, Which is effective interms of performance?

what is DYNAMIC SQL in TD?

"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

What are the available primary index types in teradata.

How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?

Explain the most common data types used in teradata?

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

On which column will you take primary index???

Explain BYNET.

Explain teradata utilities?

Explain the term 'foreign key' related to relational database management system?

For more Teradata Interview Questions Click Here