-- 这样可以吗?select userName,count(*)
from
(
select userName,
questdate
from friendinfo
where adddate(questdate,interval '10' Day)>now()
union all
select a.userName,
recvtime
from userinformation a join moqueue b
on a.mobilePhoneNo=b.srctermid
where adddate(recvtime,interval '10' Day)>now()
) t
group by userName
order by count(*) desc;
from
(
select userName,
questdate
from friendinfo
where adddate(questdate,interval '10' Day)>now()
union all
select a.userName,
recvtime
from userinformation a join moqueue b
on a.mobilePhoneNo=b.srctermid
where adddate(recvtime,interval '10' Day)>now()
) t
group by userName
order by count(*) desc;
from
(
select userName,
questdate
from friendinfo
where adddate(questdate,interval '10' Day)>now()
union all
select a.userName,
recvtime
from userinformation a join moqueue b
on a.mobilePhoneNo=b.srctermid
where adddate(recvtime,interval '10' Day)>now()
) t
group by userName
order by count(*) desc
limit 1;
哎呀!!
看我我还是要多多练习写SQL语句了.