Computers and Technology, 22.02.2021 19:20 ptrlvn01

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, 23.06.2019 18:00

Freya realizes she does not have enough in her bank account to use the debit card. she decides to use a credit card instead. which questions should freya answer before using a credit card? check all that apply. can i pay at least the minimum payment each month? can i make payments on time and avoid late fees? will i have to take out a loan? how much in finance charges can i afford to pay? should i talk to a consumer credit counseling service?

Answers: 1

Answer

Computers and Technology, 23.06.2019 19:00

Choose the correct citation for the case which established the "minimum contacts" test for a court's jurisdiction in a case. select one: a. brown v. board of education of topeka, 347 u.s. 483 (1954). b. international shoe co. v. washington, 326 u.s. 310 (1945) c. haynes v. gore, 531 u.s. 98 (2000). d. international shoe co. v. washington, 14 u.s. code 336.

Answers: 1

Answer

Computers and Technology, 23.06.2019 23:30

Match the following errors with their definitions. a. #name b. #value c. #ref d. 1. when a formula produces output that is too lengthy to fit in the spreadsheet cell 2. when you enter an invalid cell reference in a formula 3. when you type text in cells that accept numeric data 4. when you type in a cell reference that doesn’t exist

Answers: 1

Answer

Computers and Technology, 24.06.2019 01:30

Write a program that asks the user to enter the name of an input file. if the file does not exist, the program should prompt the user to enter the file name again. if the user types quit in any uppercase/lowercase combinations, then the program should exit without any further output.

Answers: 3

Answer

You know the right answer?

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

Questions