I see we have in QueryBuilder or SelectBuilder etc.
to make the params in select distinct in the query. However, how does one accomplish the following in ORM fashion ?
SQL/MYSQL QUERY EXAMPLE
SELECT DISTINCT rml.id AS locationId, COUNT(DISTINCT rm.id)
PHP Code:
->select([...])
->distinct()
SQL/MYSQL QUERY EXAMPLE
SELECT DISTINCT rml.id AS locationId, COUNT(DISTINCT rm.id)
Comment