select color, 1 as serialNumber from yourtable where color <> 'no_color' and color <> 'empty' union select color, 2 as serialNumber from yourtable where color = 'no_color' union select color, 3 as serialNumber from yourtable where color = 'empty' order by serialNumber
1条答案
按热度按时间sgtfey8w1#
可能是一个带有union的查询: