Hello everyone,
i want to extract the records with Max("revision") from a table like this:
pn1 rev1 description
pn1 rev2 description
pn2 rev1 anotherdescription
pn1 rev3 description
pn2 rev2 anotherdescription
The first column is a part number, the second is its revision index (which
is created every time the part number is modifyied).
That is quite easy in pure SQL:
SELECT
id,
pn,
revision,
description
FROM (SELECT
id,
pn,
revision,
MAX(revision)
OVER (
PARTITION BY pn ) max_rev,
description
FROM en_articles) maxart
WHERE revision = max_rev;
I cannot understand how to do the same with Django's ORM, i've tried every
combination of Subquery/Window without getting anywhere.
Does anyone know how to do it?
Thanks in advance
Marco
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/0d43b44c-996b-4dbd-86a2-d6312c8ac359%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
