Wouldn't you usually do that in your reporting software? Or on any layer
on top of the database?
In MS Access I've done it using a custom function which stores the last
value and then only outputs the next value if it is different. Not sure
how to do that in H2 ? Probably via a custom function again?
I'm not sure of other ways to make 1 row aware of the previous rows
value so you can run a calculation off it.
Can you put it into a temp table with row numbers, then join the temp
table to itself in a query to get the previous rows date value, then run
a calculation off that whether to display the date or not?
On 10/01/2014 5:43 AM, Cecil Westerhof wrote:
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.
--
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.
