Re: Get 20 most frequent pairs(2/2) and triplets(3/3) of numbers mysql

[Rick James]

There are 45 pairs and 120 triplets. Doing the task in SQL would lead to an explosion of data.

Instead, I would write it in PHP (or whatever) --
First, loop through the data:
1. read a line
2. compute the 45 pairs using 2 nested loops, $pairs[$a, $b]++
3. ditto for triplets

Then display the contents of $pairs and $triplets.