How to select last row after a group by

1

I want to select last row after group by, which means the last recorded row of each group.

select * from “adom” Where “Test Case” = ‘test_adom_create_submission_time’ GROUP BY “Build Number” ORDER BY DESC LIMIT 1

which only gives me one row, but I have multiple builds.

Thanks,

Ben

2

That query should work. A similar structure of query for me gives back one row per group. If you run it without the limit, do you get more results?

3

It’s about tag value ,and only tag value could be used in grouping , guessed the value you used was field value