Deleting one of 2 identical records

Поиск
Список
Период
Сортировка
От Gauthier, Dave
Тема Deleting one of 2 identical records
Дата
Msg-id 482E80323A35A54498B8B70FF2B8798004CFD61D01@azsmsx504.amr.corp.intel.com
обсуждение исходный текст
Ответы Re: Deleting one of 2 identical records
Re: Deleting one of 2 identical records
Re: Deleting one of 2 identical records
Список pgsql-general

Hi:

 

If I have a table that has 2 records which are identical with regard to all their column values, is there a way to delete one of them, leaving one remaining?  Is there some unique record_id key of some sort I can use for somethign like this?

 

Thanks in Advance!

В списке pgsql-general по дате отправления:

Предыдущее
От: Susan Cassidy
Дата:
Сообщение: Re: Backend process that won't die
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Deleting one of 2 identical records