两条查询SQL能不能合成一条？-灵析社区

SELECT * FROM ( SELECT * FROM t WHERE active = 1 AND enabled = 1 UNION ALL SELECT * FROM t WHERE enabled = 1 ) AS temp ORDER BY (CASE WHEN active = 1 THEN 0 ELSE 1 END) LIMIT 1 > 用 AND 链接的，程序是不是从左到右这样一个一个匹配? 是的,顺序优先级是not>and>or,除非用括号括起来