Re: [h2] How to delete duplicate rows?

2017-03-01 Thread Thomas Mueller Graf
Hi,

This is a generic SQL question, not related to H2, best asked at
StackOverflow.com.

Regards,
Thomas


On Wednesday, March 1, 2017, Imran Ahmed  wrote:

> Greetings,
>
> How do I go about deleting duplicate rows? In other words, if multiple
> rows have a same value for a specific column, how do I go about deleting
> all but one rows?
>
> Thanks,
> Imran.
>
> --
> 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 https://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.


[h2] How to delete duplicate rows?

2017-02-28 Thread Imran Ahmed
Greetings,

How do I go about deleting duplicate rows? In other words, if multiple rows 
have a same value for a specific column, how do I go about deleting all but 
one rows?

Thanks,
Imran.

-- 
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.