select * from Yao_Article where classid=10 and classid=11 and Images<>'' order by ID desc

来源：百度知道编辑：UC知道时间：2024/06/18 07:19:58

请问我想得出 classid=10 和 11 都显示出来，这样写没用。
classid=10 or classid=11 这样写也没用
classid=10,11 也没用
请教~~~

select * from Yao_Article where classid=10 and classid=11 and Images<>'' order by ID desc
改成

select * from Yao_Article where (classid=10 or classid=11) and Images<>'' order by ID desc

注意，OR的运算级别比 AND 低

select * from Yao_Article where classid=10 or classid=11 and Images<>'' order by ID desc

这样会先AND 后 OR

SELECT * FROM select from where like select *from 部系表 select sum(*) from...where..... select * from Employees select * from table SELECT * FROM TABLE select ...from之间又有select是什么意思 select * from table1 where id in (select id from table2)， select * into temp from (select * from MESSAGES)，这个对吗？