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
- 9203 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 do you mean by tpt in teradata?
Can we collect statistics on table level?
In general, how do you optimze any sql in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
what is object level locking ? where do appear this type of locking ?
Mention a few of the ETL tools that come under Teradata.
What do you mean by caching in teradata?
Define views in teradata with syntax.
List out all forms of LOCKS that are available in Teradata.
If a Node is busy what are the steps you can take to avoid ?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Explain the parallel data extension in teradata?
What is the syntax for case when statement?
What is the purpose of joins in teradata?
What are the different functions performed in development phase?
