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
- 10365 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
Explain the new features of teradata?
Describe the set operators in teradata.
What can be achieved by using the teradata rdbms?
What is a clique?
What are the updated features of teradata?
What are the design features involved in teradata?
What are the functions performed by bynet?
What is meant by Teradata Gateway?
Highlight the limitations of TPUMP Utility.
What is the difference between teradata and oracle?
Why is the case expression used in teradata?
What are the various indexes in teradata? Why are they preferred?
What does Amp contain and what are all the operations that it performs?
What are the various etl tools in the market?
What is TPD?
