I'd like one of my hole cards to equal fourth pair.

[Jackntigger]

Hi, Using LEAST, I can make one of my hole cards equal bottom pair like this:

cash_hand_player_statistics.holecard_1%13=LEAST(cash_hand_summary.card_1%13,cash_hand_summary.card_2%13,cash_hand_summary.card_3%13,cash_hand_summary.card_4%13,cash_hand_summary.card_5%13)
OR
cash_hand_player_statistics.holecard_2%13=LEAST(cash_hand_summary.card_1%13,cash_hand_summary.card_2%13,cash_hand_summary.card_3%13,cash_hand_summary.card_4%13,cash_hand_summary.card_5%13)

Is there a subquery I can run to remove the least highest board card and then re-run to match one of my hole cards with the new least board card, which would be fourth pair instead of fifth pair?

[Flag_Hippo]

Unfortunately I don't know if that's feasible although if a PostgreSQL expert sees this then they might be able to offer suggest something.