Pesron(name,age)表中年龄在26-40岁的人优先显示,其他年龄段的正常显示 select name, age fron Person where age between 26 and 40 union select name, age from Person where age <= 26 or age >= 40