How to write this sql? I have a table:
Date | Low High ------------------------------ ... 28 | 1 7 ------------------------- 29 | 1 7 29 | 2 3 29 | 4 10 ---------------------------- 30 | 1 7 30 | 2 3 30 | 4 10 ----------------------------- 31 | 0 4 31 | 6 8 I try to extract the "Date" which has the most frequently occured combination of (Low, High). For example, Date- 29, 30 should be extracted since ((1, 7), (2, 3), (4, 10)) occured more often than (1, 7) and ((0, 4), (6, 8)). I can't use GROUP BY low, high since then (1, 7) will be identified as the most frequently occured Low and High. If it is not clear, please ask me.
