Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Temprary Table の作成 --
- WITH trump AS (SELECT * FROM ( VALUES
- ('♦',1),('♦',2),('♦',3),('♦',4),('♦',5),('♦',6),('♦',7),('♦',8),('♦',9),('♦',10),('♦',11),('♦',12),('♦',13),
- ('♤',1),('♤',2),('♤',3),('♤',4),('♤',5),('♤',6),('♤',7),('♤',8),('♤',9),('♤',10),('♤',11),('♤',12),('♤',13),
- ('♣',1),('♣',2),('♣',3),('♣',4),('♣',5),('♣',6),('♣',7),('♣',8),('♣',9),('♣',10),('♣',11),('♣',12),('♣',13),
- ('♡',1),('♡',2),('♡',3),('♡',4),('♡',5),('♡',6),('♡',7),('♡',8),('♡',9),('♡',10),('♡',11),('♡',12),('♡',13),
- ('joker',0)
- ) AS t(symbol,number))
- -- 以下,temporary table: trump を用いてのクエリ --
- SELECT n1.symbol,n2.symbol, n1.number, n2.number
- FROM
- (
- SELECT number, symbol
- FROM trump
- WHERE symbol!='joker'
- ) n1
- JOIN
- (
- SELECT number, symbol
- FROM trump
- WHERE symbol!='joker'
- ) n2
- ON n1.symbol = n2.symbol
- HAVING n1.number < n2.number
- ORDER BY n1.symbol, n2.symbol, n1.number, n2.number
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement