I have the following SQL: SELECT date AS Date , SUBSTRING(time, 1, 2) AS Hour , MIN(idleTime) AS `Min Idle` , MAX(idleTime) AS `Max Idle` , COUNT(*) AS SUM FROM vmstatDefault GROUP BY Date , Hour ORDER BY Date , Hour ;
This works fine, but I would prefer to only have Date shown when it is different as the previous Date. Is this possible? -- Cecil Westerhof -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
