Re: [問題] 請問一個SQL
※ 引述《cyril63 (陽光 海與沙灘)》之銘言:
: ※ [本文轉錄自 Web_Design 看板]
: 作者: cyril63 (陽光 海與沙灘) 看板: Web_Design
: 標題: [問題] 請問一個SQL
: 時間: Fri Jun 2 18:55:14 2006
: 成績表
: Person Course Score
: =============================
: P1 Chinese 95
: P2 Chinese 98
: P3 Math 87
: P4 English 98
: SQL該如何下呢
SELECT Person, Course, Score
FROM 成績表 AS T1
WHERE exists
(
Select Person,MaxScore From
(SELECT Person,Max(Score) AS MaxScore
FROM 成績表
GROUP BY Person) AS T2
Where T1.Person=T2.Person and T1.Score=T2.MaxScore
);
寫的有點亂...囧
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 203.67.89.186
推
06/04 02:30, , 1F
06/04 02:30, 1F
推
06/04 12:46, , 2F
06/04 12:46, 2F
→
06/05 10:08, , 3F
06/05 10:08, 3F
推
06/05 15:18, , 4F
06/05 15:18, 4F
討論串 (同標題文章)