Hi everyone. I have this SQL: SELECT SUM(CASEWHEN(STATUS_ID=1,1,0))/COUNT(*) AS PERCENT_WIN FROM TICKET;
Result of this q/uery is always zero. I don't know why, both aggregations return value grater then zero that is for sure, but this does not work always ZERO!? Is this some kind of issue with h2 or not supported? I am using Version 1.3.169 (2012-09-09) on windows 7 if that is of some importance. Thank you in advance for help! bye. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/sF2h0SshWg4J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
