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 is the difference between functions and scalar functions?
how many no of arguments can be passed in procedures and functions
What is sql or structured query language?
What is page in sql server?
Explain log shipping?
What are the transaction properties?
Can two different columns be merged into single column? Show practically?
What happens if date-only values are provided as date and time literals?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Which database stores information about replication?
Explain collation?
Explain the first normal form(1nf)?
What is the difference between clustered index and primary key?
What are translations and its use? : sql server analysis services, ssas
What factors you will consider calculating the storage requirement for that view?
