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 09:30
What are the steps involved in accepting all the changes in a document? arrange these in order click edit. click accept or reject. click changes. click accept all.
Answers: 1
question
Computers and Technology, 23.06.2019 16:30
If i wanted to include a built-in calendar in a document, what option could i select? draw table insert table insert chart quick tables
Answers: 1
question
Computers and Technology, 25.06.2019 07:00
Amisfire code is a type diagnostic trouble code (dtc).
Answers: 1
question
Computers and Technology, 25.06.2019 14:00
Do the shape of a sign gives you a clue about the information contained on the sign
Answers: 1
You know the right answer?
Write a select statement that returns these columns from the products table:
the listprice co...
Questions
question
Mathematics, 19.11.2020 03:30
question
History, 19.11.2020 03:30
question
Mathematics, 19.11.2020 03:30
question
Chemistry, 19.11.2020 03:30
Questions on the website: 13722359