sql中的select 语句
发布网友
共1个回答
热心网友
SELECT Owner_id,COUNT(Owner_id) AS HYGS into #ls FROM BEFRIEND WHERE
Friend_id IN (select Friend_id from BEFRIEND where Owner_id='A') --与A共同好友关系的人
AND Friend_id!='A' --与A非好友关系
order by HYGS desc
select top 10 * from SITEUSER where Id in(select * from #ls)
