> select 12 * 10/20 = 6
>
>
> Both calculations are correct in theory. Unfortunately SQL does not deal well with decimals.
>
> If you divide a lesser number with greater number it gives a values less than 0 which SQL rounds to its nearest whole number and so you get ZERO, which is multiplied with 12 to get the same. Is there a function that can be wrapped around the 10/12 to display the decimal and not zero?
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
