作者kisha024 (4545454554)
看板Database
标题Re: [SQL ] 高考SQL题目
时间Mon Aug 15 16:06:54 2011
※ 引述《cutecpu (可爱中央处理器)》之铭言：
: 用你原本写的去改的，可以应付有多个会员拥有相同最多朋友的情况：
: select mId,name,bDate
: from Member
: where mId in (
: select friend
: from FriendRelation
: group by friend
: having count(*) = (
: select max(cnt)
: from (
: select count(*) as cnt
: from FriendRelation
: group by friend
: )
: )
: )
谢谢 我用mysql下去测 出现如下错误
#1248 - Every derived table must have its own alias
後来我改成下面就可以了
select mId,name,bDate
From Member
Where mId in (select friend
From FriendRelation
group by friend
having count(*) = (select max(T.c)
from ( select count(*) as c
From FriendRelation
group by friend ) as T)
)
感谢各位
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 220.129.5.93