MCQs > IT & Programming > LAMP > A production house has two sale outlets. Both the outlets are maintaining their data separately in servers A and B. The MD wants to see the sale of both the outlets in one report. Both the outlets use the same structure of the Sales table. Which method will you adopt to create this report?

LAMP MCQs

A production house has two sale outlets. Both the outlets are maintaining their data separately in servers A and B. The MD wants to see the sale of both the outlets in one report. Both the outlets use the same structure of the Sales table. Which of the following methods will you adopt to create this report?

Answer

Correct Answer: Select * from A.Sales union all B.Sales

Explanation:

Note: This Question is unanswered, help us to find answer for this one

LAMP Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

LAMP Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it