Posted by jim_geissman on 10/02/20 11:51

I would like to write a query that gives me the values of a set of
observations, and their rank.

CREATE TABLE #Values(val int)
INSERT #Values SELECT 1
INSERT #Values SELECT 5
INSERT #Values SELECT 10

I would like to select this:

1 10 -- rank 1, value 10
2 5
3 1

I can put them into a temp table with an identity column, ordered by
the column I'm interested in, and then retrieve in order by the
identity column. I'm wondering if there's a way to do that with a
subquery.

Thanks,
Jim

• Next in forum: Re: How to get rank?
• Prev in forum: SQLserver on SBS2003 returns old data
• Thread view: How to get rank?

[Reply to this message]