What kind of subquery is used in the following select?

What kind of subquery is used in the following select?

SELECT DISTINCT Language
FROM CountryLanguage
WHERE CountryCode IN (SELECT Code FROM Country WHERE Continents ‘Asia’)
ORDER BY Language

What kind of subquery is used in the following select?

SELECT DISTINCT Language
FROM CountryLanguage
WHERE CountryCode IN (SELECT Code FROM Country WHERE Continents ‘Asia’)
ORDER BY Language

A.
A scalar subquery.

B.
A row subquery.

C.
A column subquery.

D.
A table subquery.



Leave a Reply 0

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