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
- 10434 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
How is MLOAD Teradata Server restarted after execution?
Explain teradata utilities?
What is teradata? Also, list out some of the primary characteristics of teradata.
What are the various indexes in teradata? Why are they preferred?
List out all forms of LOCKS that are available in Teradata.
Explain and compare pros and cons of start schemas?
How can we check the version of Teradata that we are using currently?
What is collect statistics?
How do you see a ddl for an existing table?
Explain the most common data types used in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Why does varchar occupy 2 extra bytes?
What is teradata? What are some primary characteristics of teradata?
If a Node is busy what are the steps you can take to avoid ?
