查看综合仓库
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 '[名字]%')