Custom SQL field with MIN() in SELECT
Posted on 2014-09-16
I have the following SELECT statement and I am looking to create a field that will use the MIN() value on the created_at field.
I need to display what the role_name value is for the earliest value for the created_at field.
WHEN public.project_markets.market IS NULL
public.project_people_roles.name as role_name,