SELECT 123 as a, 'h' as b UNION ALL SELECT 456 as a, 'e' as b UNION ALL SELECT 789 as a, 'l' as b order by a; +-----+---+ | a | b | +-----+---+ | 123 | h | | 456 | e | | 789 | l | +-----+---+