Why is the percentage is zero

hi

Why does this statement give a 0 percent as it should be 10%? Thanks

Select 5/50 * 100

I need to cast to decimal then it would be. Thanks

Because there are INT data types .

You also can do it like this

Select 5/50.0 * 100.0

Result
10.0000000

Thanks a lot