select top5 c_name,c_stu from class where c_stu>30 and s_type=ture and请问下面语句哪里出错了?
问题描述:
select top5 c_name,c_stu from class where c_stu>30 and s_type=ture and请问下面语句哪里出错了?
select top5 c_name,c_stu from class where c_stu>30 and s_type=ture and c_name like '二班' order by c_stu asc,c_type desc
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 desc
答
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 desc
如果你想通过FIF的互教程的话,那以上就是答案!本人亲测!