Task: PostgreSQL - Select Distinct on One Column While Returning Multiple Columns
Task: PostgreSQL - Select Distinct on One Column While Returning Multiple Columns: a task in Terminal-Lego-15k (Harbor dataset). Create a PostgreSQL solution that selects multiple columns ( id , name , metadata ) from a table, but ensures uniqueness only on the name column, returning random rows…
The task
Create a PostgreSQL solution that selects multiple columns (`id`, `name`, `metadata`) from a table, but ensures uniqueness only on the `name` column, returning random rows with no duplicate names.
Part of PrimeIntellect/Terminal-Lego-15k.