What would be the outcome when following statement is executed?

What would be the outcome when following statement is executed?

SELECT Name

FROM City

WHERE CountryCode = ‘USA’ OR WHERE CountryCode = ‘JPN’

What would be the outcome when following statement is executed?

SELECT Name

FROM City

WHERE CountryCode = ‘USA’ OR WHERE CountryCode = ‘JPN’

A.
The city names from USA and JPN in one result set.

B.
The city names from USA and JPN in two different result sets.

C.
The city names from USA in the first column and the cities from JPN in the second column.

D.
An error message is issued.



Leave a Reply 0

Your email address will not be published. Required fields are marked *