SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tablename (`id` INTEGER, `num1` INTEGER, `num2` INTEGER, `num3` INTEGER);
INSERT INTO tablename (`id`, `num1`, `num2`, `num3`) VALUES
  ('1', '1', '2', '3'),
  ('2', '1', '3', '2'),
  ('3', '1', '2', '3'),
  ('4', '2', '2', '3');
SELECT COUNT(*) count,
       MIN(num1, num2, num3) num_1,
       num1 + num2 + num3 - MIN(num1, num2, num3) - MAX(num1, num2, num3) num_2,
       MAX(num1, num2, num3) num_3
FROM tablename 
GROUP BY num_1, num_2, num_3 
HAVING COUNT(*) > 1;


count
num_1
num_2
num_3


3
1
2
3