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
- 9455 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
How many types of joins are there in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Highlight a few of the important components of Teradata?
In Teradata, what is the significance of UPSERT command?
What tools would you use for that?
What do you mean by caching in teradata?
What is partitioned primary index (ppi)?
What is teradata? Also, list out some of the primary characteristics of teradata.
List out teradata data types?
Can you connect multiload from ab initio?
Explain teradata utilities?
what are the day to day activities of teradata DBA ?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is a dimension table?
What interface is used to connect to windows based applications?
