SQL - select top 10 rows with the highest number (counted)
Frager.
Hi I have a database full of records of players and theirs match Stats.
Example:
( number means goals scored in match )
What I'm, trying to do is, select top X players that scores most of goals in Season.
I'm trying something like this, but I think there must be another Select with select count (number) or something.
SELECT TOP 10 [playerID]
,[number]
,[league]
,[yearID]
,[YellowCard]
,[RedCard]
FROM [ms4033].[dbo].[Shooter]
where yearID=28 AND league=4
group by playerID
Thanks for your time :-)
Bulat
You need to SUM number field and order by it like this;
SELECT TOP 10
playerID,
SUM([number]) as goals,
[league],
[yearID],
SUM([YellowCard]) as YellowCards,
SUM([RedCard]) as RedCards,
FROM [ms4033].[dbo].[Shooter]
WHERE yearID=28 AND league=4
GROUP BY playerID, league, yearID
ORDER BY goals DESC
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
SELECT TOP 10 rows
- 2
select top 3 highest number in each group in a table
- 3
select top 3 highest number in each group in a table
- 4
Select next 20 rows after top 10
- 5
SQL select rows with number in sequence
- 6
SQL select top counts for grouped rows
- 7
SQL Select Top n percent rows
- 8
How do I select top rows in SQL
- 9
Dynamically select TOP rows in SQL Server
- 10
oracle sql select maximum top x rows
- 11
How to select top 10% of values in SQL
- 12
T SQL select top 10 loop
- 13
Return all rows where col matches that of the counted top 2
- 14
In MariaDB how do I select the top 10 rows from a table?
- 15
select sum of top 10 rows grouped by location column
- 16
how to select max top 10 (n) rows with there size?
- 17
Select top 10 rows from database and display result randomly
- 18
SQL SERVER - select distinct random number of rows
- 19
SQL select returning a defined number of rows
- 20
SQL select last 10 rows in ascending order
- 21
SQL select last 10 rows in ascending order
- 22
SQL SERVER: TOP 10 rows per field - if less than 10 rows then display empty rows
- 23
JOIN on multilple rows to SELECT only TOP row in SQL Sever
- 24
Select TOP row in SQL and get 5 rows of end table
- 25
SQL Server select (top) two rows into two temp variables
- 26
SQL Select Query Highest Value
- 27
Finding Top 15 or Top 10% Highest Values in Excel
- 28
Select multiple rows with highest rank in mysql
- 29
SELECT rows with the second highest value in a column
Comments