Blog

When you code a DELETE statement for one or more rows, the _________________ clause specifies which row or rows are to be deleted.

To create a new table by using a SELECT statement, you code the ___________________________ clause.

Which of the statements below best describes the result set returned by this SELECT statement?SELECT VendorState, COUNT(*) AS Column2FROM VendorsGROUP BY VendorStateHAVING COUNT(*) > 1;

The ____________________ data types are used to store whole numbers.

By default, all duplicate values are included in the aggregate calculation, unless you specify the ___________________________ keyword.

To insert several rows selected from another table into a table, you can code an INSERT statement with a/an ______________ in place of the VALUES clause.

A _____________ is a type of nonclustered index that includes a WHERE clause.

To relate one table to another, a/an __________________ in one table is used to point to the primary key in another table.

You can use a/an ____________________ to generate a series of integer values that can be used by more than one table.

Write an aggregate expression to find the VendorName column that’s last in alphabetical order:_________________________.