0

I don't know how to ask my question. Please see the screenshot.

Screenshot #1:

enter image description here

I have this table as shown in screenshot #1, and I want to filter it as shown in screenshot #2.

Please help do that. Thanks a lot.

Screenshot #2:

enter image description here

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
old boy
  • 1
  • Can you **explain** in plain English what you want to do? Don't just let us **guess** what you might try to achieve! – marc_s Nov 11 '20 at 10:15
  • Does this answer your question? [Select first row in each GROUP BY group?](https://stackoverflow.com/questions/3800551/select-first-row-in-each-group-by-group) – SMor Nov 11 '20 at 12:35
  • I mean with all most columns of one row are the same value except the STATUS column. When the value of the Status column is failed or passed. We have the last value is failed. Something like that. – old boy Nov 12 '20 at 01:15
  • I had a solution to this issue. thank all – old boy Nov 12 '20 at 06:15

0 Answers0