Answer Posted / dinesh waitage
1)Union is used to select distinct values from two tables
where as union all is used to select all values including
duplicates from the tables.
2)UNION - returns on Distinct rows/Slower in performance
UNION ALL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the essential components of sql server service broker?
How to create a large table with random data for index testing in ms sql server?
Can we insert data if clustered index is disabled?
Explain the ways to controlling cursor behavior?
Explain filtered indexes?
Can sql servers linked to other servers?
What is awe?
What is the report model project?
What is database replication? What are the different types of replication you can set up in sql server?
How to loop through result set objects using mssql_fetch_array()?
List the types of recovery model available in sql server?
Do you know what is a with(nolock)?
How to drop an existing table with "drop table" statements in ms sql server?
What is key set driven?
Do you know what is sql injection?
