On 2014-01-09 23:43, Cecil Westerhof wrote:
This works fine, but I would prefer to only have Date shown when it is different as the previous Date. Is this possible?
Depends on what you mean by "previous date"? You didn't show the table definition, so it's hard to know. In general, filtering when you are using GROUP BY means using a HAVING clause. -- 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.
