perly ended"
> I'm unfamiliar with this syntax (update ... from ... where). Was this
> properly constructed?
>
>
> From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On
> Behalf Of Michael Bayer
> Sent: Monday, October 13, 2014 8:53 PM
>
... from ... where). Was this
> properly constructed?
>
>
> From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On
> Behalf Of Michael Bayer
> Sent: Monday, October 13, 2014 8:53 PM
> To: sqlalchemy@googlegroups.com
> Subject: Re: [sqlalchemy] how
mmand not properly ended"
I'm unfamiliar with this syntax (update . from . where). Was this properly
constructed?
From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On
Behalf Of Michael Bayer
Sent: Monday, October 13, 2014 8:53 PM
To: sqlalchemy@googlegroups.com
in Oracle I'd update the table based on a SELECT from a window function:
SELECT row number OVER (PARTITION BY employee_id ORDER BY id) FROM employee
that should give you "1, 2, 3, ..." for each row within an employee id group
On Oct 13, 2014, at 1:44 PM, Ofir Herzas wrote:
> I have found a so