Question

Code example 12-1 Select VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal From Vendors Inner Join Invoices On Vendors.VendorID = Invoices.VendorID Where InvoiceTotal >= 500 Order By VendorName Desc (Refer to code example 12-1.) How many columns will the result set have?

Answer 1

4

Step-by-step explanation:

From the given query, four columns are been called when we study the query closely.

Select VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal From Vendors Inner Join Invoices On Vendors.VendorID = Invoices.VendorID Where InvoiceTotal >= 500 Order By VendorName Desc

The column are VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal.

And the table name is Vendors.

With inner join on another table called Invoices

On Vendors.VendorID = Invoices.VendorID

Where InvoiceTotal >= 500

Order By VendorName in descending order

So, from the above the resultset will have four (4) columns.