How can you calculate whether the result is a decimal or a whole number in SQL?

I want to check whether the result is a decimal or an integer. So that it can be done in a manipulation or an existing function?
For example:

select case when a/b = integer then 1 when a/b = decimal then 2 end  from test

• if a = 10 and b = 2 the result should be 1.
• if a = 11 and b = 2 the result should be 2.

thanks.

>Solution :

You can do this too

SELECT 
    CASE 
        WHEN a % b = 0 THEN 1
        ELSE 2 
    END AS result
FROM 
    test;