标记正确.先前的查询在语法上不正确. 使用虚拟别名应该有效！

EDIT : Mark is correct. The earlier query was syntactically incorrect. Using dummy aliasés should work!

Select id from
(
    SELECT id FROM table_name 
    WHERE id >= 3 
    ORDER BY id ASC
) X   

UNION

Select * from
(
    SELECT id FROM table_name 
    WHERE id < 3 
    ORDER BY id ASC
) Y

这应该给您3,4,5,1,2

This should give you 3,4,5,1,2