建表语句:
create table follow
(followee varchar2(5),
follower varchar2(5));
insert into follow values('A', 'B');
insert into follow values('B', 'C');
insert into follow values('B', 'D');
insert into follow values('D', 'E');
查询语句:
SELECT DISTINCT F2.FOLLOWER,F1.COUNTS
FROM(SELECT FOLLOWEE,COUNT(DISTINCT FOLLOWER) COUNTS
FROM FOLLOW GROUP BY FOLLOWEE) F1
INNER JOIN FOLLOW F2
ON F1.FOLLOWEE=F2.FOLLOWER
ORDER BY F2.FOLLOWER;