posted by .

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 -

    Sorry, but "sql" does not identify the School Subject for us. Please look to the upper left-hand column in red.


Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. keybording and word processing

    7. to adjust a column's width in a table, you should?
  2. SQL for Business

    By using this table: CREATE TABLE Part ( Partid int IDENTITY PRIMARY KEY, Supplierid int NOT NULL REFERENCES Part (PartID), Description VARCHAR (25) NOT NULL, Count int NOT NULL, Class VARCHAR (5) NOT NULL, Inspection smalldatetime …
  3. SQL

    1- A SQL statement is needed to create a stored procedure that has one input parameter of data type int. The stored proc selects the supplierId field and the total, or sum, of all Count field values for each group of supplierId fields …
  4. Algebra

    1.What is the shape of the graph of any linear function?
  5. SQL for business help

    I have no idea where to begin with this. A SQL statement that creates a user defined function that returns an int value is needed. This int return value is obtained by deducting the lowest Count field value from the highest Count field …
  6. Chemistry

    I have 2 questions on columns used in the Gas Chromatography-Flame Ionisation Detector (GC-FID) instrument: - 1) If a capillary column is left in the GC-FID instrument for 2 months with the instrument switched off (i.e. instrument …
  7. programming

    I need help with a C++ exercise. I need to write a code to display a table consisting of four rows and 11 columns. The first column must contain the numbers 1 through 4 and the other columns must contain the result of multiplying the …
  8. Excel Filtering

    Hi I'm trying to filter data between 3 different columns. I want it so the data filtered so data in column a is smaller than column b, which is smaller than column c. I try to filter but it only allows me to use filter criteria from …
  9. business

    wall street journal provides the net asset value, the year to date percent return, and the three year percent return for 555 mutual funds will be selected for a follow up study on the size and performance of mutual funds. Use the forth …
  10. Algebra

    J is the set of all fractions in the form of a/(a)square where a cannot not equal to 0 Column A: a (any member of set J) Column B: 1 A. Quantity in column A is greater B. Quantity in column B is greater C. two quantities in both columns …

More Similar Questions