asked on
Get Top 20 by value per name
Hello Experts,
How do I get the top 20 by Charges for each Store Name ?
I know this is just easy but I cannot figure it out.
See example attached.
Thank you for all your help.
GetTheTop20ChargesByStoreName.xlsx
How do I get the top 20 by Charges for each Store Name ?
I know this is just easy but I cannot figure it out.
See example attached.
Thank you for all your help.
GetTheTop20ChargesByStoreName.xlsx
Microsoft SQL ServerSQL
Last Comment
Scott Pletcher
ASKER
@Scott,
Thank you for your help.
Your query is perfectly correct but I asked the wrong question.
Is there a way I can reverse if Top 20 by Store Name on Charges?
Show only top 20 Store Name. I know my example has only 4 store name.
Thank you.
Thank you for your help.
Your query is perfectly correct but I asked the wrong question.
Is there a way I can reverse if Top 20 by Store Name on Charges?
Show only top 20 Store Name. I know my example has only 4 store name.
Thank you.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Notice too that I had to make a correction to my other code, maybe that would give you the actual solution you need too.
ASKER
Sorry about that.
ASKER
@Scott:
Thank you for all your help.
Thank you for all your help.
No worries, glad it helped.
FROM (
SELECT *, ROW_NUMBER() OVER(PARTITION BY StoreName ORDER BY Charges DESC) AS row_num
FROM dbo.your_table_name
) AS query1
WHERE row_num <= 20 /*CORRECTION from earlier code, which had row_num = 1*/
ORDER BY StoreName, Charges DESC