Real Postgres "DISTINCT ON" query...

[Foddy]

Hi,

does anyone know how I can make this query using Medoo's select function? I hope I can avoid using the raw query method:

SELECT DISTINCT ON (guests."group") *
FROM guests

I'm unfortunately not making progress with the distinct function in the documentation. The results are completely different. My goal is to only retrieve the first entry when multiple rows have the same group ID.

[Foddy]

No one... 😮‍💨?