mysql ladder

ladder.sql

CREATE TABLE `ladder` (
  `i` int(1) unsigned NOT NULL,
  PRIMARY KEY (`i`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO ladder (i) VALUES (0), (1), (2), (3), (4), (5), (6), (7), (8), (9);

SELECT l1.i + l2.i * 10 + l3.i * 100 AS sequence
FROM ladder l1
JOIN ladder l2 ON TRUE
JOIN ladder l3 ON TRUE
ORDER BY sequence DESC;