SQL query to delete rows when one column is empty and a combination of another three exists without an empty string

Vote count:

0

I have something like this:

id_flow    id_question    order               questionText
   1            2           1        How do I remove the row below?"
   1            2           1          
   1            1           2      

we wouldn't want to remove the third row because no other combination (1,1,2) exists... but we would want to remove the second.

I am probably missing basic SQL concept here, but can someone help?

asked 32 secs ago

Joseph Nields

576

SQL query to delete rows when one column is empty and a combination of another three exists without an empty string