查看综合仓库 SELECT * FROM TBL_PublicWarehouse WHERE (FLD_ID = '帐号')
查询等级>80 SELECT TOP 100 * FROM TBL_Char WHERE (FLD_ID NOT IN (SELECT TOP 100 FLD_ID FROM rxjhgame.dbo.TBL_Char)) AND (FLD_LEVEL > 80) ORDER BY FLD_LEVEL DESC, FLD_NAME
等级排行榜 SELECT TOP 10 * FROM rxjhgame.dbo.TBL_Char WHERE (FLD_ID NOT IN (SELECT TOP 10 FLD_ID FROM rxjhgame.dbo.TBL_Char)) ORDER BY FLD_LEVEL DESC, FLD_NAME
查询帐号 SELECT * FROM rxjhACCOUNT.dbo.TBL_ACCOUNT WHERE (FLD_ID = '帐号'')
SELECT * FROM rxjhgame.dbo.TBL_Char WHERE (FLD_ID = '帐号'') 查询名字 SELECT * FROM TBL_Char WHERE (FLD_NAME = '名字)
模糊查询名字 SELECT * FROM TBL_Char WHERE (FLD_NAME LIKE '[名字]%')
|