No, sorry, that's not valid SQL at all.
They have to be executed as separate statements.
SELECT COUNT(*) FROM TEST WHERE (t2-t1) > 1000)
SELECT COUNT(*) FROM TEST WHERE (t2-t1) <= 1000)
SELECT COUNT(*) FROM TEST
or like this, if you really needed the efficiency:
SELECT ((t2-t1) > 1000), COUNT(*)
FROM TEST
GROUP BY (t2-t1) > 1000
And then you'd have to add the values from the result set yourself to
get the total.
On 2013-06-19 12:18, Uli wrote:
Hi,
after reading the documentation about the COUNT aggregate function
(http://www.h2database.com/html/functions.html#count) I would expect
that it is possible to have a conditional COUNT.
But it does not seem to work as the test program below shows. It
creates a table with two colums t1 and t2. t2 is always > t1. The
program should count all rows with t2-t1 > 1000 and t2-t1 <= 1000. But
both counts returns the number of all rows so it does not mention the
conditions.
Should this be supported in H2?
Thanks!
Uli
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
