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, 22.06.2019 16:20
Octothorpe is another name for what common computer keyboard symbol?
Answers: 1
question
Computers and Technology, 22.06.2019 22:30
Jason needs to learn a new web tool. he went through his books to understand more about it. now he wants hands-on experience with using that tool. what would him? jason can use websites where workspace is provided to test the results of your code.
Answers: 2
question
Computers and Technology, 23.06.2019 08:30
When you interpret the behavior of others according to your experiences and understanding of the world your evaluation is
Answers: 1
question
Computers and Technology, 23.06.2019 14:30
Select the correct answer. peter has launched a website that features baby products. however, clients often find they are unable to access the website because the server is down. which feature of cybersecurity should peter focus on for his website? a. data authenticity b. data privacy c. data availability d. data integrity e. data encryption
Answers: 3
You know the right answer?
Write a SELECT statement that returns these columns from the Products table: The ListPrice column
Questions
question
Mathematics, 11.03.2021 23:00
question
Mathematics, 11.03.2021 23:00
question
History, 11.03.2021 23:00
question
English, 11.03.2021 23:00
question
English, 11.03.2021 23:00
Questions on the website: 13722367