I wonder if someone can help me with this SELECT statement. My table has
columns subm_no, portion and premium. Portion can be either P or P1.
Occasionally you'll have rows with the same subm_no but different
subm_no portion premium
39792 P 1000
39792 P1 4000
In such a situation, if the P1 row has premium > 0, the SELECT statement
should display ONLY the row with portion = 'P', but for its premium it
should display the premium of the row with portion = P1:
39792 P 4000
If there is no P1 row, just show the P row. ...