Computers and Technology, 27.02.2020 17:26 kaveon2019

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;

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 08:30

1.the index finger on your right hand types the f r v 4 j u m 7 h y 6 n lo.9 j u 7 m g t 5 b 2.if you need to multiply 400, 2, and 1 ½, what would you type on the numeric keypad? 400*2*1.5 400/2*1.5 400/2/1.5 400*2*1½ 3.select all examples of proper keyboarding technique. rest your fingers gently on the home row or home keys. slouch in your chair. rest your palms on the keyboard. relax your fingers. keep your hands lower than your elbows.

Answers: 1

Answer

Computers and Technology, 22.06.2019 14:30

If the polar bear were taken out of the food chain what would happen to the seal population the seal population would diminish the seal population would grow dramatically the seal population would stay the same the seal population would decrease slightly

Answers: 1

Answer

Computers and Technology, 22.06.2019 17:40

Gabe wants to move text from one document to another document. he should copy the text, paste the text, and open the new document highlight the text, select the cut command, move to the new document, make sure the cursor is in the correct location, and select the paste command select the save as command, navigate to the new document, and click save highlight the text, open the new document, and press ctrl and v

Answers: 1

Answer

Computers and Technology, 22.06.2019 20:30

In this lab, you complete a prewritten c program that calculates an employee’s productivity bonus and prints the employee’s name and bonus. bonuses are calculated based on an employee’s productivity score as shown below. a productivity score is calculated by first dividing an employee’s transactions dollar value by the number of transactions and then dividing the result by the number of shifts worked.

Answers: 3

Answer

You know the right answer?

Write a SELECT statement that returns these columns from the Products table:
The ListPrice col...

Questions