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
- 9454 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
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
List out all forms of LOCKS that are available in Teradata.
Steps to create a data model?
Different phases of multiload?
What are the different methods ot loading a dimension table? A fact table etc?
Highlight a few of the advantages that ETL tools have over Teradata.
What do you mean by fastexport in teradata?
What are the functions of a teradata dba?
Discuss the advantages of using partitioned primary index in a query?
Syntax for case when statement?
How do you define Teradata?
Explain the term 'columns' related to relational database management system?
What is spool space?
What is difference between user and database in teradata?
What do you mean by parsing?
