Which of the following SQL statements correctly retrieves th…
Which of the following SQL statements correctly retrieves the columns in the order: VendorFirstName, VendorLastName, and VendorName from the Vendors table, and sorts the results first by VendorLastName and then by VendorFirstName in Acending Order? A. SELECT VendorFirstName, VendorLastName, VendorName FROM Vendors ORDER BY VendorFirstName, VendorLastName;B.SELECT VendorFirstName, VendorLastName, VendorName FROM Vendors ORDER BY VendorLastName, VendorFirstName;C.SELECT VendorName, VendorFirstName, VendorLastName FROM Vendors ORDER BY VendorLastName, VendorFirstName;D. SELECT VendorFirstName, VendorLastName, VendorName FROM Vendors ORDER BY VendorFirstName DESC, VendorLastName DESC;
Read DetailsWhich of the following SELECT statements returns three colum…
Which of the following SELECT statements returns three columns from the Invoices table, named Number, Total and Balance where: Number: Column alias for the InvoiceNumber columnTotal: Column alias for the InvoiceTotal columnBalance: InvoiceTotal minus the PaymentTotal, minus the CreditTotal A. SELECT InvoiceNumber, InvoiceTotal, BalanceFROM Invoices;B.SELECT InvoiceNumber, InvoiceTotal, InvoiceTotal – PaymentTotal – CreditTotal AS Number, Total, BalanceFROM Invoices;C.SELECT InvoiceNumber AS Number, InvoiceTotal AS Total, InvoiceTotal + PaymentTotal + CreditTotal AS BalanceFROM Invoices;D.SELECT InvoiceNumber AS Number, InvoiceTotal AS Total, InvoiceTotal – PaymentTotal – CreditTotal AS BalanceFROM Invoices;
Read Details