Blog

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:_________________________.

Code example 4-2SELECT VendorName, InvoiceNumberFROM Invoices LEFT JOIN Vendors  ON Invoices.VendorID = Vendors.VendorID; (Refer to code example 4-2.) The total number of rows returned by this query must equal

SQL Server comes with complete documentation and reference information called ____________________________________.