Get startedGet started for free

Data type precedence

In this exercise, you will evaluate the rating information from the ratings table and you will see what happens when a decimal value is compared to an integer. Remember: in SQL Server, data is implicitly converted behind the scenes from one type to another, in such a way that no data loss occurs.

This exercise is part of the course

Functions for Manipulating Data in SQL Server

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT 
	bean_type,
	rating
FROM ratings
WHERE ___;
Edit and Run Code