Get the last created records

Ask the community
,
1

Hi,
I’d like t get the most recent record of each unique value.
Let’s say I have a field named “object” and the values are:

  1. object: “table”; createdDate: 2019-04-02

  2. object: “table”; createdDate: 2019-04-01

  3. object: “table”; createdDate: 2018-09-09

  4. object: “chair”; createdDate: 2019-02-03

  5. object: “chair”; createdDate: 2019-01-03
    and I’d like to get the last created record s of each unique value of object (in this example number 1 AND number 4). The object values are not fixed (so I can’t specify them in the query itself). What should be the query?

Thanks,
J.D.