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?

Question

Marcus Freeman

Computers & Technology

7 May, 07:19

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?

+5

Answers (1)

Know the Answer?

Shamar Cherry · Answer 1

4

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.