How to select last row after a group by

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.



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?

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