Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
SQL Server Rank Query Optimization
CREATE TABLE users (id int, country varchar(20)); INSERT INTO users VALUES (1, 'United States'), (2, 'Mexico'), (3, 'United States'), (4, 'United States'), (5, 'United States'), (6, 'Mexico') CREATE TABLE leaderboard (id int, score int); INSERT INTO leaderboard VALUES (1, 75), (2, 66), (3, 99), (4, 95), (5, 70), (6, 85); ----Our Current Leading Method --SELECT u.id AS user_id, u.country, lu.score, RANK() OVER (ORDER BY lu.score DESC) AS rnk --FROM users u --INNER JOIN leaderboard lu ON u.id = lu.id --WHERE country = 'United States' --My Suggestion SELECT u.id AS user_id, u.country, lu.score, RANK() OVER (ORDER BY lu.score DESC) AS rnk FROM (select * from users WHERE country = 'United States') u INNER JOIN leaderboard lu ON u.id = lu.id
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
SQL injection
MyDb
SQL Sequence
new
Basic Except
OUTER JOIN
tarefaum
forming date as nvarchar
Microsoft SQL Server T-SQL in 10 minutes - products
bc160401882
Please log in to post a comment.