mysql表查詢實(shí)例-資料下載頁
2025-08-21 12:43本頁面
【正文】 ELECT ,name,SUM(grade) FROM student,score WHERE = GROUP BY 。13 SELECT c_name,AVG(grade) FROM score GROUP BY c_name。14 SELECT * FROM student WHERE id IN (SELECT stu_id FROM score WHERE c_name=’計(jì)算機(jī)’ AND grade95)。15 SELECT * FROM student WHERE id=ANY (SELECT stu_id FROM score WHERE stu_id IN(SELECT stu_id FROM score WHERE c_name=’計(jì)算機(jī)’ )AND c_name=’英語’)。16 SELECT stu_id,grade FROM score WHERE c_name=’計(jì)算機(jī)’ ORDER BY grade DESC。17 SELECT id FROM student UNION SELECT stu_id FROM score。18 SELECT ,name,sex,birth,department,address,c_name,grade FROM student,score WHERE (name LIKE ‘張%’ OR name LIKE ‘王%’) AND =。19 SELECT ,name,sex,birth,department,address,c_name,grade FROM student,score WHERE address LIKE ‘湖南%’ AND =。
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1