The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [rank]

The tag has no usage guidance.

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
30 views

Exclusive and Inclusive ranking queries in Postgres 9.6

I'm trying to build a filtering/ranking search that would let me order and optionally filter out people based on a 1-to-many relationship with job "focuses". The tables are shown at the bottom. A "...
0
votes
1answer
28 views

Help me to RANK correctly in Access

I have such a table: I want to rank the people, as who has the more V1 and the less V2, V3, V4, V5 be on top. Please advise me SQL code for MS-ACCESS.
0
votes
1answer
45 views

Fetch 10 paginated ranked posts of each category

Posts table as p: | id | cid | score | ... -------------------- | 1 | 1 | 3 | ... Categories Table as c: | id |... -------------------- | 1 |... What i need? Reterive paginated ranked ...
0
votes
0answers
25 views

How to rank mysql with groupby

Guy I am trying to ranking some data from my database, and I notice that it's going very wrong when I put the group by clause; SET @rank=0; SELECT @rank:=@rank+1 AS RankSemGenero ,a.nome AS ...
0
votes
0answers
61 views

Rank users by different periods and overall

I'm trying to create a ranking system for a game which should have 2 different rankings. Below you will find the Model (or the result after querying the database) which should be presented to the ...
0
votes
1answer
125 views

Create a temp table that consolidates start and end dates plus generates a uniqueid for each consolidated record

I have a table called projecthistory, it is actually a view so I could take advantage of the Rank function to get a unique record number. From this view I need to create a temp table that has a ...