Sorry, I misinterpreted what you were trying to do.
You are right, it wouldn't work :)
On 2/02/2011 10:56 PM, Kasper Sørensen wrote:
Can you actually do that? I need all the values also, to see which are
the duplicates, so maybe something like:
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]
<mailto:[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]
<mailto:[email protected]>.
To unsubscribe from this group, send email to
[email protected]
<mailto: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.
--
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.
