如何使用查询dense_Rank()和rank()? [英] How to use query dense_Rank() and rank()?
本文介绍了如何使用查询dense_Rank()和rank()?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,我遇到了一个关于如何使这个值变得下降的问题。这是我在桌上的数据排名:
名称|分数
杰克| 3
Mia | 2
Jon | 5
黑色| 8
Meisye | 10
我已经尝试了我的查询:
SELECT 名称,等级( ) OVER ( ORDER BY 得分 ASC ) AS RankScore
FROM 排名
但它仍然无法正常工作。任何人,请帮忙。谢谢。
解决方案
升序:
SELECT 名称,rank() OVER ( ORDER BY 得分 Asc ) AS rankcore
FROM 等级
降序:
SELECT 名称,排名() OVER ( ORDER BY 得分 DESC ) AS rankcore
FROM Rank
试试这样..
选择得分,DENSE_RANK()结束(按分数排序)作为Rank1的排名
检查出来 [ ^ ]
Hi guys, I got a problem about how to make this value become descending. Here is my data on table Rank :
Name | Score
Jack | 3
Mia | 2
Jon | 5
Black | 8
Meisye | 10
I have tried my query :SELECT Name, rank() OVER (ORDER BY Score ASC) AS RankScore FROM Rank
But it still can't work. Anyone, please help. Thanks.解决方案ascending:
SELECT Name, rank() OVER (ORDER BY Score Asc) AS rankscore FROM Rank
Descending:
SELECT Name, rank() OVER (ORDER BY Score DESC ) AS rankscore FROM Rank
Try like this..
select score, DENSE_RANK() over(order by score) as rank from Rank1
Check this out[^]
这篇关于如何使用查询dense_Rank()和rank()?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文