1. 学习
  2. /
  3. 课程
  4. /
  5. Intermediate SQL Server

Connected

练习

Rounding numbers

Sometimes, you only care about the whole dollar amount and want to ignore the decimal values of the cost. In this exercise, you will round the cost to the nearest dollar.

说明

100 XP

Write a SQL query to round the values in the Cost column to the nearest whole number.