[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: Re: [SQL] SQL conversion help
From: Thomas Kellerer <spam_eater () gmx ! net>
Date: 2017-05-22 6:30:50
Message-ID: ofu0ik$qo$1 () blaine ! gmane ! org
[Download RAW message or body]
Ertan Küçükoğlu schrieb am 20.05.2017 um 06:01:
> I have below SQL script used in SQL Server. I would like some help to
> convert it into PostgreSQL format, please.
>
> DECLARE @satirno INT
> SET @satirno = 0
> UPDATE urtrecetedet
> SET @satirno = satirno = @satirno + 1
> WHERE recetekodu = 'ASD'
Assuming your primary key column is named ID, you can do it like this:
update urtrecetedet u
set satirno = t.rn
from (
select id,
row_number() over (order by id) as rn
from urtrecetedet
where recetekodu = 'ASD'
) t
where t.id = u.id;
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic