Homework Help: sql

Posted by Anonymous on Monday, September 19, 2011 at 2:21pm.

Write a SELECT statement that returns four columns based on the InvoiceDate column of the Invoices table:
• Use the CAST function to return the first column as data type varchar.
• Use the CONVERT function to return the second and third columns as a varchar, using style 1 and style 10, respectively.
• Use the CAST function to return the fourth column as data type real.

sql - SraJMcGin, Monday, September 19, 2011 at 8:51pm
Sorry, but "sql" does not identify the School Subject for us. Please look to the upper left-hand column in red.

Sra

Answer this Question

Related Questions

SQL for business help - I have no idea where to begin with this. A SQL statement...
programming - I need help with a C++ exercise. I need to write a code to display...
SQL server help! - A SQL statement is needed to create a stored procedure, which...
keybording and word processing - 7. to adjust a column's width in a table, ...
SQL for Business - By using this table: CREATE TABLE Part ( Partid int IDENTITY...
software - What does this mean: "Using the columns feature,select the ...
SQL - 1- A SQL statement is needed to create a stored procedure that has one ...
Chemistry - I have 2 questions on columns used in the Gas Chromatography-Flame ...
geometry - write the statement in symbols using the p and q given below. Then ...
English - I am ask to creat a table that lays out a day-by-day plan to use as a ...

For Further Reading

First Name:
School Subject:
Answer: