I wrote UDF as workaround but I don't want to use it if it is not necessary. Anyone?
On Wednesday, October 3, 2012 6:40:18 PM UTC+2, Gordam Gordam wrote: > > 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/-/IzI0yQCjQhcJ. 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.
