With C as (
Select row_number() over partition by (list, all, columns, here order by
oid) as rn
)
Delete
>From C
Where rn > 1;
On Jan 1, 2014 7:15 AM, "Janek Sendrowski" wrote:
> Hi,
>
> I want to delete duplicates in my table. I've dropped the unique
> constraint to insert my data.
> My id valu
You could also look into a filtered index that perhaps only covers dates
earlier than a certain point in time where regular performance wouldn't be
hindered. But Gavin is absolutely right otherwise.
On Jan 5, 2014 5:22 PM, "Sergey Konoplev" wrote:
>
> On Sun, Jan 5, 2014 at 2:19 PM, Gavin Flower
Hi,
I've been developing for MS SQL around four years. I'm starting out with
some work in Postgresql next week, and I'd like to know if there's any
equivalent way to do something like this (from my word press)
http://sqldriver.wordpress.com/2013/12/09/generating-inserts-dynamically/
My question
Thank you Pavel. That's exactly what I needed to get started.
On Jan 6, 2014 3:25 AM, "Pavel Stehule" wrote:
> Hello
>
>
>
> 2014/1/6 Erik Darling
>
>> Hi,
>>
>> I've been developing for MS SQL around four years. I'm starting out wi
unsubscribe
On Sun, Feb 2, 2014 at 11:28 AM, Gavin Flower wrote:
> On 03/02/14 01:18, Edson Richter wrote:
>
>> Em 02/02/2014 04:24, John R Pierce escreveu:
>>
>>> On 2/1/2014 4:26 PM, Adrian Klaver wrote:
>>>
On 02/01/2014 03:26 PM, John R Pierce wrote:
> On 2/1/2014 3:18 PM, Eds
