Hi Imran, apart from Thomas' quite valid remark, if you want a column to hold unique values only, it would be best to avoid duplicates up front - by either having a UNIQUE constraint on the column, or even using it as primary key.
Hope that helps, Carsten Am Mittwoch, 1. März 2017 07:50:06 UTC+1 schrieb 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
