Answer Posted / dinesh sharma
Union:Only Select Distinct Value
Union All:Select All Values Using Duplicate
All Selected Columns Must Have Same DataType
Example:
Table 1 : First,Second,Third,Fourth,Fifth
Table 2 : First,Second,Fifth,Sixth
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between a having clause and a where clause.
What is bit data type? What's the information that can be stored inside a bit column?
How to rebuild the master database?
How to set the current database in ms sql server?
Using the customer, and order table in northwind database, please write a query to produce xml?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
How to drop an existing schema in ms sql server?
Define msdb database?
whats new about truncate in sql server 2008?
what are the disadvantages of cursors? : Sql server database administration
What are the different Topologies in which Replication can be configured?
What is the difference between having clause and where clause in sql server?
What are different types of raid levels?
What are the different acid properties?
when you create a database how is it stored? : Sql server database administration