ROUND()

If we’d like to convert a column to only use integers (so excluding the decimals), we can use SQL’s ROUND function:

SELECT Country, City, ROUND(Year, 0)

FROM database_table

  • The ROUND function can be especially useful when certain data has many decimal places, and you’re trying to make sense of the data but it can be difficult to deal with when there’s so many decimal points. The ROUND function can make life much easier overall and is a useful function in the SQL toolkit.