with tb1 as (
select Id,count(*) as cnt
from example
group by Id
)
select t1.No,t1.Name
from example t1
inner join tb1 on t1.No = t2.Id
order by t2.cnt desc
※ 引述《rrr0832 (rrr0832)》之銘言：
: If there is a table name "example" like below:
: http://i.redwh.al/Ef.png
: How do I select the name which "No" has the most occurrence in other rows' "Id
: "?
: Here's my try:
: http://i.redwh.al/Ld.png
: The result should be like this:
: http://i.redwh.al/T7.png
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 210.61.233.210
※ 文章網址: https://www.ptt.cc/bbs/Database/M.1516607013.A.C76.html