subject

Write a SELECT statement that returns these columns from the Products table: The ListPrice column
A column that uses the CAST function to return the ListPrice column with 1 digit to the
right of the decimal point
A column that uses the CONVERT function to return the ListPrice column as an integer
A column that uses the CAST function to return the ListPrice column as an integer

MY CODE:
SELECT ListPrice,
CAST(ListPrice AS decimal)
CONVERT(decimal, ListPrice)
CAST(ListPrice AS Int)
FROM Products;

ansver
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 19:30, tfaulk2884
Singing in the rain: this first part of the film shows the early history of motion picture. how accurate do you think the portrayal of the early motion picture industry is? why? is historical accuracy important in films and theater productions? explain.
Answers: 1
image
Computers and Technology, 23.06.2019 01:30, shelley3135
For a typical middle-income family, what is the estimated cost of raising a child to the age of 18? $145,500 $245,340 $304,340 $455,500
Answers: 2
image
Computers and Technology, 23.06.2019 02:30, jalaholmes2027
Three out of five seniors remain undecided about a college major at the end of their senior year.
Answers: 3
image
Computers and Technology, 24.06.2019 12:50, opgbadwolf5
When is it most apprpriate for a development team to change the definition of done
Answers: 1
You know the right answer?
Write a SELECT statement that returns these columns from the Products table: The ListPrice column

Questions in other subjects:

Konu
Social Studies, 04.03.2021 17:20
Konu
Mathematics, 04.03.2021 17:20