Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
Stuff code in sql
SQL_RankingFunctions
Create Index On Viiew
Cristina
sum vs count with multiple options in group by clause
Insert multiple parent-child records
mc170403050
see a quell
ms sql 3
2021-03-09_LeetCodeSQL