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?
- 3 Answers
- 9140 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / aarsh dave
The first query will only show the records that are matching
on id and deptno = 10.
The second query will show all the records from table A with
B.t1 as NULL wherever deptno <> 10.
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
Highlight a few of the important components of Teradata?
What is the purpose of indexes?
What is called partitioned primary index (ppi)?
What do you mean by tpt in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are the design features involved in teradata?
What are the updated features of teradata?
What tools would you use for that?
What do you mean by teradata intellicloud?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is bteq utility in teradata?
Explain teradata architecture in detail with a diagram.
How is MLOAD Client System restarted after execution?
What is teradata?
What is bteq script in teradata?
