What all are the joins in Teradata?...

Inner Join: It will return the matches records from multiple tables and we can able to use maximum 128 tables and views for per query block.

Cross Join:The CROSS JOIN is used to generate a paired combination of each row of the first table with each row of the second table. This join type is also known as cartesian join. (Referred : SqlShack)...Thanks SqlShack.




Outer Join:

    1. Left Outer Join: Return all the records from Left table and will return only matches records from right table.

    2. Right Outer Join: Return all the records from right table and will return only matches records from left table.

    3. Full Outer Join: it will combine left and right tables and will return matches and non matches records.

Self join: 

A single table considered as a two tables by using correlation names to rederive the records.


Comments

Post a Comment

Popular posts from this blog

General information about Netezza : Default Error details

General information about Netezza : Default Error details     There are around 140 default error details available in Netezza. For your reference please find below details. ERRORCODE ERRORTEXT 1 Operation failed 2 Interaction aborted 3 Statement aborted 4 Could not serialize - transaction aborted 5 Transaction no longer active 6 Out of memory 7 Incorrect data type 8 Illegal value 9 Internal: SPUs crosstalking 10 Internal pipe I/O failed 11 Cannot determine hostname 12 Rogue SPU trying to register 13 No such table exists 14 No such field exists in table 15 Table already exists 16 Plan already exists in plan dictionary 17 F...
Read more

Minus in Teradata?...

Minus : It will provide the result which one is not matching from both tables... Note: It will provide the not matching result from first select table only. Select Emp_No from Emp Minus Select Emp_no from Emp_Dep;
Read more