A_T_C Posted October 24, 2009 at 12:22 AM Report Share #293126 Posted October 24, 2009 at 12:22 AM Boa noite! Alguem sabe como é a divisão em sql (postgres) que não seja inteira? ? Link to comment Share on other sites More sharing options...
Baderous Posted October 24, 2009 at 01:29 PM Report Share #293159 Posted October 24, 2009 at 01:29 PM Vê este exemplo: As an example of mathematical operators in the target list, the statement in Example 5-9 takes the retail price for each book and divides the cost with the / operator in order to determine the profit margin. This value is then typecast to a truncated numeric value with only two digits of precision. Finally, the integer constant 1 is subtracted from the division result, to yield only the percentage points over 100. http://www.faqs.org/docs/ppbook/c7547.htm#USINGMATHEMATICALOPERATORS Link to comment Share on other sites More sharing options...
A_T_C Posted October 31, 2009 at 02:53 PM Author Report Share #294165 Posted October 31, 2009 at 02:53 PM Muito Obrigada 😉! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now