Sqlite 联合和排序顺序

Question

select 'none', '0'
union
select * from category where id='2'

我可以检索上述sqlite 查询的输出，因为'none' 应该始终是第一项吗？即我想阻止两个结果集的组合排序。请帮忙...

Answer 1

select * from
(
select 'none' as col1, '0' as col2 union  select  * from category where id='2' 
) t
order by case when col1='none' then 0 else 1 end