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
- 10249 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
What is meant by a Clique?
What is the function of parser component in teradata?
What are the main components of teradata system?
Difference between stored procedure and macro?
What are the available primary index types?
What are the different functions performed in development phase?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the things to be considered while creating secondary index?
What is the difference between teradata and basic rdbms?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is meant by Teradata Gateway?
Where is teradata rdbms used?
What is a clique?
Differentiate database data and data warehouse data?
how can we analyze the locks ?
