Write select statement based on the invoicetotal column


Problem

Write select statement based on the InvoiceTotal column of the Invoices table:

i. Use the CAST function to return the first column as an integer value. Name it IntTotal.

ii. Use the CAST function to return the second column as datatype decimal with one digit to the right. Name it DecimalTotal.

iii. Use the CONVERT function to return the third column as a datatype that outputs 2 digits to the right of the decimal point and all comma's to the left. Name it FormatTotal

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write select statement based on the invoicetotal column
Reference No:- TGS03242737

Expected delivery within 24 Hours