finding a row with the max value between different rows

how i need a query such that eliminates rows like 160 (if a and id is in conflicting slots column only return the row with maximum conflictin slots) (id is int and conflictig slots is text (can change to int as well) thx a lot

ID      |    conflicting_slots
============================
150     |       150,151
160     |       161,160
161     |       159,160,161 


Read more here: https://stackoverflow.com/questions/64416499/finding-a-row-with-the-max-value-between-different-rows

Content Attribution

This content was originally published by JesterTester at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: