Distinct queriesΒΆ

You can fetch distinct columns using distinct_on argument. Initial order_by columns must match distinct_on columns. Learn more about order_by here.

employee (
  distinct_on: [employee_select_column]
  order_by: [employee_order_by]
): [employee]!

#select column enum type for "employee" table
enum employee_select_column {
  id
  name
  department
  salary
}

For example, fetch highest salaried employee from each department:

query {
  employee(
    distinct_on: [department]
    order_by: [{department: asc}, {salary: desc}]
  ){
    id
    name
    department
    salary
  }
}
query { employee( distinct_on: [department] order_by: [{department: asc}, {salary: desc}] ){ id name department salary } }
{ "data": { "employee": [ { "id": 5, "name": "Kamila", "department": "Engineering", "salary": 4325 }, { "id": 4, "name": "Damien", "department": "Product", "salary": 3124 }, { "id": 7, "name": "Rickard", "department": "Services", "salary": 2223 } ] } }