会SQL的进来看下

来源:百度知道 编辑:UC知道 时间:2024/05/05 16:55:53
http://p1.images22.51img1.com/6000/xiaobaozaici/15088ed1d4a6c59c76aafc5dad821c92.jpg
我填的两种答案都不合适
1,select c_name, c_stu from class where c_stu>50 or c_stu<20
2,select c_name, c_stu from class where c_stu between 50 and 20
求救呀 填不正确视频教程不能继续看下去

是卡皮球和卖烧烤主持的

1,select c_name, c_stu from class where c_stu>50 and c_stu<20

2,select c_name, c_stu from class where c_stu not between 50 and 20

fif的视频 吧?卡皮球和卖烧烤主持的?

select c_name, c_stu from class where c_stu not(between 20 and 50)

,select c_name, c_stu from class where c_stu not( between 50 and 20)

select c_name, c_stu from class where c_stu between 20 and 50 试试反过来。你所写的查询语句都是正确的;可能是你填写时符号没用好。

select * from class where c_stu>50 or c_stu<20 group by c_name,c_stu;