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
- 10554 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
Highlight all the modes that are present under Confidence Level.
In general, how do you optimze any sql in teradata?
What are the functions involved in shared information architecture?
Highlight the advantages of PPI(Partition Primary Index).
What do you mean by ttu in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is primary index and secondary index?
What are the steps involved in the process flow of the sql statement through channel attached system?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the meaning of Caching in Teradata?
What are types of partition primary index (ppi) in teradata?
Highlight the need for Performance Tuning.
What is basic teradata query language?
What are the available join types in teradata?
What are the various indexes in teradata? How to use them?
