SELECT “date” AS “Date”, “2” AS “2”, “3” AS “3”, “4” AS “4”, FROM “table” WHERE “date” > ‘1919-01-01’ AND “4” LIKE ‘%100%’ ORDER BY “date” DESC
In this query, there may be several duplicate instances of values in “3”. Can this query be modified to select only the most recent instance of each value?