SQLize Online / PHPize Online  /  SQLtest Online

create table api_site_results ( id int, var_val int, id_res_id int, var_id_id int, device_id varchar, var_val_conv numeric ); insert into api_site_results values (11,126 ,3864 ,36 ,'abc123' ,1.21), (10,136 ,3764 ,36 ,'abc123' ,1.51), (9 ,115 ,3582 ,35 ,'abc123' ,4.41), (8 ,143 ,2464 ,36 ,'abc123' ,8.81), (7 ,226 ,1844 ,35 ,'abc123' ,9.21), (6 ,12 ,3364 ,34 ,'abc123' ,11.7); SELECT * FROM api_site_results as VR ; WITH ids AS (SELECT DISTINCT first_value(id) over (partition by var_id_id order by id desc) id FROM api_site_results as VR ) SELECT * FROM ids JOIN api_site_results USING(id);