在select查询中隐藏列？

vq8itlhq 于 2021-08-13 发布在 Java

关注(0)|答案(2)|浏览(389)

嗨，我试图隐藏在我的结果中显示的totalrank列，因为我只需要在这个查询中使用它来帮助排序项目。我不需要显示这些信息。

SELECT TOP 15 G.CharacterName, G.JobCode, G.PvPExp, D.PVPWin, D.PVPLose, D.PVPGiveUp, RANK() OVER (ORDER BY TotalRank ASC ) as TotalRank
FROM PvPRanking as G
INNER JOIN PVPScores as D
ON G.CharacterID = D.CharacterID

sql window-functions sql-order-by

来源：https://stackoverflow.com/questions/62078461/hide-column-in-select-query

2条答案

按热度按时间

tzxcd3kk1#

您可以使用以下命令

SELECT TOP 15 G.CharacterName, G.JobCode, G.PvPExp, D.PVPWin, D.PVPLose, D.PVPGiveUp
FROM PvPRanking as G
INNER JOIN PVPScores as D
ON G.CharacterID = D.CharacterID
ORDER BY  RANK() OVER (ORDER BY TotalRank ASC )

赞(0）回复(0）举报 2021-08-13

t30tvxxf2#

您可以创建结果表的别名，并从中选择除total rank列之外的所有内容。

SELECT t1.CharacterName, t1.JobCode, t1.PvPExp, t1.PVPWin, t1.PVPLose, t1.PVPGiveUp
FROM 
(SELECT TOP 15 G.CharacterName, G.JobCode, G.PvPExp, D.PVPWin, D.PVPLose, D.PVPGiveUp, 
RANK() OVER (ORDER BY TotalRank ASC ) as TotalRank
FROM PvPRanking as G
INNER JOIN PVPScores as D
ON G.CharacterID = D.CharacterID) AS t1

赞(0）回复(0）举报 2021-08-13

我来回答

在select查询中隐藏列？

2条答案

相关问题

热门标签

最新问答