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:
:

: How do I select the name which "No" has the most occurrence in other rows' "Id
: "?
: Here's my try:
:

: The result should be like this:
: