Search code examples
sqlsql-server

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;