Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 181316 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / nafisul haque
Join returns matching/non matching records as per condition
where as union returns union of recordsets. Join is used
within single select statement while union is used among
two or more select statements.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What do we need to check in database testing?
What are tuples in sql?
What is scope and visibility in PL/SQL?
What are the two types of exceptions in pl/sql?
How do you pronounce sql?
How much does sqlite cost?
How many commands are there in sql?
How do you use collections in procedure to return the resultset?
Explain unique key in sql.
how to show all tables with 'mysql'? : Sql dba
What is the difference between clustered and non-clustered indexes?
what are the properties and different types of sub-queries? : Sql dba
Why commit is not used in triggers?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Is pl sql a programming language?
