2020-11-16QQ数据库

QQ数据库

QQ数据库查询

查询QQ号码为88662753的用户的所有好友信息

select * from Relation where QQID=88662753 and RelationStatus=1

效果展示

查询QQ号码为286212的用户的好友中每个省份的总人数，并且总人数按由大到小排序

select * from Relation where QQID=286212 and RelationStatus=0

select Province as 省份,count(1) as 总人数 from Relation
inner join
BaseInfo
on
Relation.RelationQQID = BaseInfo.QQID
where 
Relation.QQID = 286212
group by Province;

效果展示

查询QQ号码为286224的好友中等级为10级以上的“月亮”级用户信息

select * from Relation where QQID=286224 and RelationStatus=0

select Relation.QQID from 
Relation 
inner join 
QQUser
on
Relation.RelationQQid = QQUser.QQID
inner join
BaseInfo
on
Relation.RelationQQid = BaseInfo.QQID
where 
QQUser.QQLevel >=10 
and 
Relation.QQID=286224

效果展示

查询被当做黑名单人物次数排名前20的用户

select top 20 RelationQQID,count(1) as 次数 from Relation
where 
RelationStatus = 1
group by RelationQQID
order by count(1) desc

效果展示