热血江湖SQL部分常用命令

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

商业版发布站程序下载：发布站程序下载：

Tags：

作者：佚名