Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between in and exists.
Ex: select * from emp where empno in(....) and
select * from emp where empno exists(....)
What is the difference between a Join and Union and Union
and UnionAll.
- 5 Answers
- 11443 Views
- ABC, Accenture, I also Faced
- E-Mail Answers
Answer Posted / saradhi
Just like JOINS, UNION combines data into a single record-
set but vertically by adding rows from another table. JOINS
combine data horizontally by adding columns from another
table.
UNION insures you get DISTINCT records from both the tables.
UNION ALL pulls out all records from both the tables with
duplicates.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
mention different types of relationships in the dbms?
Do you know what is sql injection?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
Explain data warehousing in sql server?
What is the difference between mysql and mysqli?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What are four major operators that can be used to combine conditions on a where clause?
What are the database objects? : SQL Server Architecture
Explain in brief about Microsoft SQL server?
How do I create a trace in sql server?
Why do we need normalization?
Can you insert NULL in unique column?
Do you know what is normalization of database? What are its benefits?
What are the different types of triggers in SQL SERVER?
