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
- 10421 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 are the steps to create a data model?
What is logical data model?
What is meant by a dispatcher?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is the basic syntax for teradata select statement?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are different table types used in teradata?
During the Display time, how is the sequence generated by Teradata?
What happens when a node suffers a downfall?
what are the uses of fact table and dimension table in banking project?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Explain teradata architecture?
What is the difference between fastload and multiload? Which one is faster?
What is meant by a node?
What are the various indexes in teradata? Why are they preferred?
