uj5u.com熱心網友回復：
SELECT Student.Sno,Student.Sname,course.name
FROM Student
JOIN scores
ON Sno = scores.Sno
JOIN Course
ON Cno = scores.Cno
WHERE sudent.name='張三'
uj5u.com熱心網友回復：
謝謝大佬，但是sno和cno前也得加表名 ON student.Sno = scores.Sno on course.cno=scores.cno的
uj5u.com熱心網友回復：
第二個怎么做，大神，求指點
uj5u.com熱心網友回復：
SELECT dbo.Student.Sno,name,t1.ccount FROM (
SELECT TOP 10 * FROM (
SELECT sno,COUNT(1) AS ccount FROM scores
)t ORDER BY t.ccount DESC)t1 JOIN dbo.Student ON t.sno = dbo.Student.Sno
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/124706.html
標籤：疑難問題
上一篇：kingbase es v8
下一篇：求