Can you actually do that? I need all the values also, to see which are the duplicates, so maybe something lik <[email protected]>e:
SELECT COUNT DISTINCT a,b,c,d,e,f FROM my_table but to my knowledge that is not a valid query? /Kasper On Wed, Feb 2, 2011 at 3:43 PM, Ryan How <[email protected]> wrote: > Hi, > > What about > > SELECT COUNT DISTINCT FROM my_table > > I know it doesn't solve the actual issue, but it may be a workaround for > now? > > Cheers, Ryan > > > > On 2/02/2011 7:09 PM, Kasper Sørensen wrote: > >> SELECT a,b,c,d,e,f,g,COUNT(*) FROM my_table GROUP BY a,b,c,d,e,f,g >> >> > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<h2-database%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
