#order-by

LIMIT/OFFSET with DISTINCT and ORDER BY: inconsistent behavior across SQLAlchemy dialects

Goal To paginate a distinct result set in a cross‑dialect application using SQLAlchemy’s core select construct. Constraints SQLAlchemy generates dialect‑specific SQL for LIMIT/OFFSET. The interaction of DISTINCT, ORDER BY, and pagination is documented but not fully unified. Unresolved Behavior When a query contains SELECT DISTINCT column FROM table ORDER BY

Community & Careers · Editorial question

distinctsqlalchemylimits