还是SELECT 查询语句
答案:5 悬赏:10 手机版
解决时间 2021-07-19 20:29
- 提问者网友：临风不自傲
- 2021-07-18 21:15
还是SELECT 查询语句
最佳答案
- 五星知识达人网友：北方的南先生
- 2021-07-18 21:57
SELECt c_name, s_no, s_name
FROM class, stu
WHERe c_stu > 20 AND s_no like '_006%' AND stu.s_cid = class.s_cid
ORDER BY s_no;
全部回答
- 1楼网友：雪起风沙痕
- 2021-07-19 00:57
Select c_name,s_no,s_name
From class join stu on c_id = s_cid
Where c_stu>20 and
substring(s_no,2,4) = '006'
Order By s_no desc
- 2楼网友：酒者煙囻
- 2021-07-18 23:47
SELECt c_name, s_no, s_name FROM class,stu
WHERe s_cid=s_cid AND c_stu>20 AND s_no LIKE '_006%'
ORDER BY s_no DESC;
- 3楼网友：未来江山和你
- 2021-07-18 23:03
select c_name,s_no,s_name from class,stu
where class.s_cid=stu.s_cid and c_stu>20
and s_no like '_006%' order by s_no asc
- 4楼网友：逃夭
- 2021-07-18 22:38
Select c_name,s_no,s_name
From class join stu on c_id = s_cid
Where c_stu>20 and
substring(s_no,2,4) = '006'
Order By s_no
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯