0

I have the following table. For each rsptxt_question_fk, I want to get the rsptxt_text_response where rsptxt_id_pk is the highest. Meaning that I want my output to be (48, abc, 1, 33) and (51, def, 8, 22). Does anyone know how to achieve this?

enter image description here

Bear
  • 25
  • 4
  • 2
    Does this answer your question? [Get top 1 row of each group](https://stackoverflow.com/questions/6841605/get-top-1-row-of-each-group) – Thom A Jul 15 '22 at 16:01
  • That's exactly it @Larnu, thank you very much! – Bear Jul 15 '22 at 16:13

0 Answers0