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
Can you name some of the dml commands in sql?
Define self join?
What are a database and a data warehouse?
Does transparent data encryption provide encryption when transmitting data across the network?
Explain in details security in SQL azure?
what are different types of raid configurations? : Sql server database administration
What are the advantages to use stored procedures?
What is t-sql script to take database offline – take database online.
What are pessimistic lock and optimistic lock?
Can binary strings be converted into numeric or float data types?
What's the information that can be stored inside a bit column?
How to drop existing indexes in ms sql server?
What are four major operators that can be used to combine conditions on a where clause?
What are transactions and its controls?
Explain the disadvantages/limitation of the cursor?