Question

A production house has two sales outlets. Both outlets are maintaining their data separately in schemas A and B respectively The Management wants to see the sale of both outlets in one
report. Both outlets are using tables called Sales which have identical structure. Which method you will adopt to create the report?
Correct answer:+1
Incorrect answer.0​

Answer 1

Explanation:

yryrtryryt7ewyyyey6e6eyattaysueus7sd87dyfyfyfugigugugyfufufhhssbwnnsndbdnzjdbhfbdjddjududududhdjekdkdiiddoisdkkdjdsjhdhdgrhdgdhdhjdjdhdjdjdjdhjdjdbsbsbsbssghshshsydyduudjsjshshshgsgsgshhshshshshhshshshshdhhdhdhhdhdhdhhd

Answer 2

Select * from A.Sales union all B.Sales

A production house has two sales outlets. Both outlets are maintaining their data separately in schemas A and B respectively The Management wants to see the sale of both outlets in one report. Both outlets are using tables called Sales which have identical structure.

• When using the Union operator, the results of two or more searches are combined into a single, distinct result set that contains all the rows that are related to all of the Union's questions. This process combines two additional inquiries and eliminates duplicate results.
• When comparing Union and Union All, we discover that while they are relatively similar, they differ significantly in terms of performance outcomes.
• With the Union operator, you may aggregate the output of two or more queries into a single result set that contains every row that was returned by every Union-related query. In layman's terms, it combines the duplicate rows from two or more row sets.
• The following is where UNION and UNION ALL diverge most: ONLY KEEP UNIQUE RECORDS: UNION All records, including duplicates, are kept by UNION ALL.
• A SELECT DISTINCT is effectively performed on the results set by a UNION command. Use UNION ALL to get quicker results if you are certain that every record returned is distinct from the others from your union.

#SPJ2