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
- 10369 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / aarsh dave
The first query will only show the records that are matching
on id and deptno = 10.
The second query will show all the records from table A with
B.t1 as NULL wherever deptno <> 10.
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
why use references rather than pointers in the public api, particularly for arguments which are modified?
Define views in teradata with syntax.
Explain the new features of teradata?
What is meant by a Clique?
What do you mean by teradata intelliflex?
How to find duplicates in a table?
What are the various indexes in teradata? How to use them?
What is the purpose of using case expression in teradata?
Explain teradata architecture in detail with a diagram.
Why are oltp database designs not generally a good idea for a data warehouse?
What is the difference between teradata and oracle?
What is the use of having index on table?
Explain the term 'columns' related to relational database management system?
What are default access rights in teradata? What explicit right can be given to a user?
What do you mean by caching in teradata?
