Mehawitchi
asked on
How to Club Rows in One Row As Others - SQL Server
Hello experts,
The following SQL query yields Results #1 (see below)
SELECT Top 10 ChGroupName AS GROUPNAME, SUM(SCORE) AS SCORE, RANK() OVER(ORDER BY SUM(SCORE) desc) AS RANKING
FROM SmryTable
GROUP BY ChGroupName
ORDER BY RANKING
I need to alter the above query to make it list top 4 and club entries from 5 onwards as OTHERS, so that the results will look like the following:
Thanks for your help,
Hani
The following SQL query yields Results #1 (see below)
SELECT Top 10 ChGroupName AS GROUPNAME, SUM(SCORE) AS SCORE, RANK() OVER(ORDER BY SUM(SCORE) desc) AS RANKING
FROM SmryTable
GROUP BY ChGroupName
ORDER BY RANKING
I need to alter the above query to make it list top 4 and club entries from 5 onwards as OTHERS, so that the results will look like the following:
Thanks for your help,
Hani
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS 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.
SOLUTION
THIS SOLUTION IS 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.
Line 19 has typo. Please change
FROM ce2;
to
FROM cte2;
FROM ce2;
to
FROM cte2;
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
I will test and get back to you with feedback.
Best,
Hani