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
- 10255 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
What is multi insert?
What is meant by a Highest Cost Plan?
What is meant by a Least Cost Plan?
Explain Teradata performance tuning and optimization?
How to find duplicates in a table?
Highlight the advantages of PPI(Partition Primary Index).
Explain teradata utilities?
How to run a query in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are the uses of bynets in multi-node systems?
How many codd's rules are satisfied by teradata database?
What are the available primary index types?
Explain the meaning of Amp?
What are some primary characteristics of teradata?
