Finding 'rank' of entry in sql database efficiently
29700
How best to get someone's 'rank' from a scores table with php and mysql without looping
121738
How to find the nth highest salary in SQL?
118170
SQL -- How is DISTINCT so fast without an index?
15850
How to select the nth row in a SQL database table?
36815
SQL: how to select a single id ("row") that meets multiple criteria from a single column
60257
How does database indexing work?
96534
Efficiently select beginning and end of multiple contiguous ranges in Postgresql query
35057
What is the simplest SQL Query to find the second largest value?
58576
How to get ranks with no gaps when there are ties among values?
93655
How to prove the lack of implicit order in a database?
83284
The most efficient method to obtain the total entries into a mysql table
91887
Select statement to find duplicates on certain fields
12835
How to efficiently find positions of duplicates?
22985
SQL query that gives distinct results that match multiple columns
80391
T-SQL: Selecting Column Based on MAX(Other Column)
46339
How do I compare 2 rows from the same table (SQL Server)?
96184
Ordering by the order of values in a SQL IN() clause