Link to home
Create AccountLog in
Avatar of nutnut
nutnutFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL Syntax: Why does SELECT 1/2 return 0 and not 0.5?

Hi

Why does SELECT 1/2 return 0 and not 0.5?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of EvilPostIt
EvilPostIt
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of nutnut
nutnut
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thanks its been driving me mad!!