SELECT DISTINCT ON support for DBs besides PostGRES

Using Django Using the ORM
1

I recently migrated my back end from PostGRES to MySQL. I was surprised to find out about the lack of support for “distinct” queries outside of PostGRES, per the documentation. Why is this? Thanks.

2

it not related to django but to the db itself , since mysql doesn’t support “distinct on” django couldn’t use it.

3

Thanks for the info. I would seem that maintaining access to “distinct” queries by field would be ideal. Was there no way to write a method for a "select distinct [columnA], [columnB], … " statement for MySQL and other dbs that don’t support “distinct on”?

4

the only db i know supports it is postgres