Examveda

The following MySQL statement is valid.
SELECT abc, xyz FROM table1 UNION abc, def FROM table2;

A. True

B. False

Answer: Option A

Solution (By Examveda Team)

This question asks if the given MySQL statement is valid. Let's break it down:
Understanding the SQL Statement:
* `SELECT abc, xyz FROM table1` This part selects the columns `abc` and `xyz` from the table `table1`. * `UNION` This keyword combines the results of two queries. It only includes unique rows from both datasets. * `abc, def FROM table2` This part seems to be trying to select columns `abc` and `def` from the table `table2`. However, it's missing the `SELECT` keyword, which makes it invalid.
Why the statement is incorrect:
The statement is incorrect because it's missing the `SELECT` keyword in the second part. To combine queries using `UNION`, both queries need to be complete `SELECT` statements.
The correct way to write the statement:
```sql SELECT abc, xyz FROM table1 UNION SELECT abc, def FROM table2; ```
Therefore, the answer is Option B: False.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous