Ask Question
11 January, 11:03

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?

+1
Answers (1)
  1. 11 January, 11:57
    0
    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.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Code example 12-1 Select VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal From Vendors Inner Join Invoices On Vendors. VendorID = ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers