-- 六 查询数据
SELECT QQID,NickName,Age FROM BaseInfo WHERE QQID='88662753'
SELECT * FROM QQUser WHERE Online=0
SELECT * FROM BaseInfo a,QQUser b WHERE(a. Age >=18 AND Age <=45 ) AND a.Province='北京市' and b.Online=0
SELECT * FROM BaseInfo WHERE NickName='秋芙蓉'
SELECT Province,COUNT(Province) FROM Relation b,Baseinfo c WHERE (b.QQID='54789625' and b.RelationStatus=0 and b.RelationQQID= c.QQID)
Group BY Province ORDER BY COUNT(Province) DESC
SELECT QQID,LastLogTime,Online,[Level] FROM QQUser
WHERE DATEDIFF(DD,LastLogTime,GETDATE())>150 ORDER BY DATEDIFF(DD,LastLogTime,GETDATE()) DESC
--等级大于2级的
SELECT RelationQQID,NickName,Age,[Level] FROM Relation C
INNER JOIN BaseInfo as b ON C.QQID='54789625' and C.RelationStatus=0 and c.RelationQQID=b.QQID
INNER JOIN QQUser as E ON C.RelationQQID=E.QQID AND E.Level>=2
--隐身的
SELECT RelationQQID,
十三章QQ项目查询 删除插入
最新推荐文章于 2019-06-06 16:15:16 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)