注册
登录
| 关键词： stu name where class classselect type like select age order |
学习参考答案 SQL1:select * from classselect c_id,c_name from classselect c_name,c_stu from class where c_stu>50 or c_stu<20SQL2:模糊查询select top 5 c_name,c_stu from class where c_stu>30 and c_type=true and c_name like '*二班*' order by c_stu asc,c_type descSQL3:多表联合查询select c_name,s_no,s_name from class,stu where c_id=s_cid and c_stu>20 and s_no like '?006*' order by s_no descSQL4:增加，删除，修改insert into class (c_name,c_stu,c_type) values ('三年二班',45,false)delete from stu where s_age>45update stu set s_age=s_age-1 where s_no like '?6?1*' |
|
| 友情提醒：以上链接来自互联网，请注意风险！ |
|
声明：文章版权归原作者所有 部分文章转自互联网 如有侵权请联系
[邮箱地址] 删除
|
