combination_tramp_part_same.sql

SELECT n1.symbol,n2.symbol, n1.number, n2.number
FROM
(
  SELECT number, symbol
  FROM trump_part
  WHERE symbol!='joker'
) n1
JOIN
(
  SELECT number, symbol
  FROM trump_part
  WHERE symbol!='joker'
) n2
ON n1.symbol = n2.symbol
HAVING n1.number < n2.number
ORDER BY n1.symbol, n2.symbol, n1.number, n2.number