Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10418 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 are the different design perspectives used in teradata?
How does hashing happens in teradata?
What is the purpose of indexes?
Explain the meaning of Amp?
What is the purpose of joins in teradata and what are the available join types?
What is the difference between fastload and multiload? Which one is faster?
Can we collect statistics on multiple columns?
How to run a query in teradata?
Mention a few of the ETL tools that come under Teradata.
What are the steps involved after the disk manager passes the request?
how many modules are there in telecome domain?how to explain the architecture?
If a Node is busy what are the steps you can take to avoid ?
What are the different functions included in the server software?
What are the scenarios in which full table scans occurs?
Steps to create a data model?
