...

Quiz Yourself: Subqueries

Test your knowledge of subqueries in T-SQL.

We'll cover the following...

Subqueries Quiz

Consider the following query:

INSERT INTO Orders (CustomerId, ItemId, Price, Address, OrderDate)

(Select all that apply.) Which option(s) are valid for the above INSERT INTO statement?

SELECT * FROM OrderHistory;

SELECT Id, Id FROM Items;

SELECT ClientNumber, ArticleId, SalesPrice, DeliverTo, GETDATE() FROM DeliveryHistory;

SELECT ClientName, ArticleName, SalesPrice, DeliverTo, GETDATE() FROM DeliveryHistory;

1 / 5

Quiz Yourself: Subqueries