Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 14127 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / valarmathi
union is used to retreive the data with out duplication
union all is used to retreive the data with duplication
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
What are indexers?
What is SQL Server?
How to rebuild master databse?
What are the indexes in sql server?
What are different replication agents and what's their purpose? : sql server replication
Please explain what is “asynchronous” communication in sql server service broker?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Difference between aggregate functions of sql?
What is lock escalation and what is its purpose?
Explain what is dbcc?
What is inner join in sql server joins?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
What is data compression? : sql server database administration
how to trace the traffic hitting a sql server? : Sql server database administration
