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

Another question on Computers and Technology

question
Computers and Technology, 24.06.2019 06:30
Ineed to know the anwser to all these questions
Answers: 2
question
Computers and Technology, 25.06.2019 01:30
What controls can be found on the file tab of microsoft word
Answers: 1
question
Computers and Technology, 25.06.2019 02:30
What are the charges for invasion of privacy on computers
Answers: 1
question
Computers and Technology, 25.06.2019 08:10
Spreadsheet software is more powerful than financial planning software. - true or false
Answers: 2
You know the right answer?
Write a SELECT statement that returns these columns from the Products table:
The ListPrice col...
Questions
question
Mathematics, 12.11.2020 21:50
question
Chemistry, 12.11.2020 21:50
question
Mathematics, 12.11.2020 21:50
question
History, 12.11.2020 21:50
Questions on the website: 13722361