How Can Queries Be Combined And What Is The Use?
Answers
Answered by
0
Answer:
To combine result set of two or more queries using the UNION operator, there are the basic rules that you must follow:
First, the number and the orders of columns that appear in all SELECT statements must be the same.
Second, the data types of columns must be the same or convertible.
Similar questions
Geography,
6 months ago
English,
6 months ago
Computer Science,
6 months ago
Business Studies,
11 months ago
Biology,
11 months ago
Physics,
1 year ago
Social Sciences,
1 year ago
Accountancy,
1 year ago