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
- 10547 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 meant by a Least Cost Plan?
How many tables can you join in v2r5?
What is meant by a node?
Why do you get spool space errors? How do trouble-shoot them?
What type of indexing mechanism do we need to use for a typical data warehouse?
Syntax for case when statement?
What is the use of teradata system software?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How you will check the version of teradata?
What do you mean by teradata intelliflex?
What are the newly developed features of Teradata?
What are the enhanced features in teradata v2r5 and v2r6?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the scenarios in which full table scans occurs?
What are the multiload utility limitations?
