[DiscordArchive] Do you want it to only show the highest count (as in the count of 4) or several highest?
[DiscordArchive] Do you want it to only show the highest count (as in the count of 4) or several highest?
Original source
Do you want it to only show the highest count (as in the count of 4) or several highest?
rektbyfaith
06-02-2022, 03:10 PM #1Archived author: ACHERAX • Posted: 2022-06-02T15:10:52.875000+00:00
Original source
Do you want it to only show the highest count (as in the count of 4) or several highest?
Original source
ORDER BY
rektbyfaith
06-02-2022, 03:11 PM #2Archived author: Deleted User • Posted: 2022-06-02T15:11:46.297000+00:00
Original source
ORDER BY
Original source
Eg if you changed `COUNT(*)` to `COUNT(*) as total` you could then do `ORDER BY total DESC`
rektbyfaith
06-02-2022, 03:13 PM #3Archived author: Deleted User • Posted: 2022-06-02T15:13:13.974000+00:00
Original source
Eg if you changed `COUNT(*)` to `COUNT(*) as total` you could then do `ORDER BY total DESC`
Original source
https://www.w3resource.com/sql/aggregate...oup-by.php
[Embed: SQL MAX() function with GROUP by, ORDER by - w3resource]
SQL MAX() function with GROUP by, ORDER by: How the GROUP BY and ORDER BY clause along with the SQL MAX() can be used to find the maximum value of a column over each group.
https://www.w3resource.com/sql/aggregate...oup-by.php
rektbyfaith
06-02-2022, 03:18 PM #4Archived author: Deleted User • Posted: 2022-06-02T15:18:19.294000+00:00
Original source
https://www.w3resource.com/sql/aggregate...oup-by.php
[Embed: SQL MAX() function with GROUP by, ORDER by - w3resource]
SQL MAX() function with GROUP by, ORDER by: How the GROUP BY and ORDER BY clause along with the SQL MAX() can be used to find the maximum value of a column over each group.
https://www.w3resource.com/sql/aggregate...oup-by.php
Original source
I don’t think you can do MAX(COUNT(*)), it throws an error.
rektbyfaith
06-02-2022, 03:20 PM #5Archived author: Peacy • Posted: 2022-06-02T15:20:55.891000+00:00
Original source
I don’t think you can do MAX(COUNT(*)), it throws an error.
Original source
Use distinct
rektbyfaith
06-02-2022, 03:31 PM #6Archived author: Foe • Posted: 2022-06-02T15:31:38.970000+00:00
Original source
Use distinct
1 Guest(s)
1 Guest(s)