Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Delete duplicate rows in a Table?

    Hi,

    Try with this query

    Delete from [dbo].[folders_rel] where id not in

    (Select Min(id) from [dbo].[folders_rel]

    group by folder_id, polymorphic_id)

    I hope this works. If this is incorrect kindly let me know.

    thanks,

    niranjan.

Viewing post 1 (of 1 total)