Question

CODE EXAMPLE 3-1 SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotal FROM vendors INNER JOIN invoices ON vendors .vendorID = invoices.vendorID WHERE invoiceTotal >= 500 ORDER BY vendorName DESC How many columns will the result set have?

Answer 1

Answer:

The correct answer for the given question is 4

Explanation:

In the given code it select the vendorName, invoiceNumber, invoiceDate, invoiceTotal from vendors ,invoices table. when required condition is fullfill i.e vendors .vendorID = invoices.vendorID and invoiceTotal >= 500 .

So their are 4 column in the result set i.e vendorName, invoiceNumber, invoiceDate, invoiceTotal .