Quiz Yourself: T-SQL Basics
Test your knowledge of the basic syntax of T-SQL.
We'll cover the following...
We'll cover the following...
T-SQL Basics Quiz
1.
Consider the following dbo.Orders table.
| OrderId | ItemId | Quantity |
|---|---|---|
| 1 | 25 | 4 |
| 2 | 2 | 7 |
| 3 | 11 | 1 |
(Select all that apply.) Which of the given option(s) will result in the following output?
| OrderId |
|---|
| 1 |
| 3 |
A.
SELECT OrderId FROM dbo.Orders
WHERE OrderId = 1 OR OrderId = 3;
B.
SELECT OrderId FROM dbo.Orders
WHERE Quantity < 4;
C.
SELECT OrderId FROM dbo.Orders
WHERE OrderId = 1 AND OrderId = 3;
D.
SELECT OrderId FROM dbo.Orders
WHERE Quantity < 6;
1 / 5