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
- 9165 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / rkraju
Hi..,guys.,
joins concepts we are not use where conditions on queries
>>so in that above query we are using where instead of and.
so that is the difference b/w this two queries......,,,,,,,,
>>if any ones knows better result send me..,,
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why teradata is used?
What is the purpose of using case expression in teradata?
What is collect statistics?
Highlight the advantages of PPI(Partition Primary Index).
How do you determine the number of sessions?
What is a node in teradata? Explain
What is the primary index in teradata?
How is MLOAD Client System restarted after execution?
What happens in a conflict? How do you handle that?
What is the purpose of indexes?
What is meant by a dispatcher?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is meant by a Parsing Engine?
Explain and compare pros and cons of start schemas?
What interface is used to connect to windows based applications?
