十三章QQ项目查询 删除插入

--  六   查询数据

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,