sql语句 and 和 or 的问题
首先感谢大家进来看这个问题.
我的问题如下：
1、以下结果是？
select * from student where kemuA>60 and classNo = 310630 and sex =1 or classNo =310640 and sex=0；
2、以下结果是？
select * from student where （kemuA>60 and classNo = 310630 and sex =1 ）or（classNo =310640 and sex=0）；
3、有区别吗？以下结果是？
select * from student where (classNo = 310630 and sex =1) or (classNo =310640 and sex=0) ；
select * from student where classNo = 310630 and sex =1 or classNo =310640 and sex=0 ；
4、有区别吗？以下结果是？
select * from student where classNo = 310630 and sex =1 and ( kemuB>70 and kemuA>60 or kemuB>50 and kemuA>80 and kemuC>70) ；
select * from student where classNo = 310630 and sex =1 and ( (kemuB>70 and kemuA>60 )or (kemuB>50 and kemuA>80 and kemuC>70)) ；
[解决办法]
你的数据呢？ 否则怎么回答你？
