Suppose I have a table as :
It may have duplicate items in it.I know two ways in which this can be done.
- making a new table.
- adding distinct items from the first table to it.
- dropping the previous one.
- renaming it to the previous table.
Other way is in which we use indexes but since it requires memory for indexes I don't want to use that either.
Can someone suggest a simple way to delete duplicates from the table.
PS:I am using Postgres.
