```kotlin SELECT * FROM ( SELECT DISTINCT ON (ad...

# exposed

[Brian Carbone]

kotlin
SELECT * FROM (
  SELECT DISTINCT ON (address_id) *
  FROM purchases 
  WHERE product_id = 1
  ORDER BY address_id, purchased_at DESC
) t
ORDER BY purchased_at DESC

what is the equivalent of this in exposed?

[Timur Atakishiev]

https://github.com/JetBrains/Exposed/issues/248

[tapac]

@Brian Carbone, please look at https://github.com/JetBrains/Exposed/issues/500 for DISTINCT ON expression workaround.

[Brian Carbone]

@tapac I did that, but it's the nested query I had trouble with