Updating tinyint columns in oracle
This benchmark does not include very complex queries.
The embedded mode of H2 is faster than the client-server mode because the per-statement overhead is greatly reduced.
It is an interesting problem in Transact SQL, for which there are a number of solutions and considerable debate.
How do you go about producing a summary result in which a distinguishing column from each row in each particular category is listed in a 'aggregate' column?
Version 1.4.177 (2014-04-12) was used for the test.