---
title: "Topplista"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/21639-topplista"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Andy"
published: "2001-10-02T08:44:00.000Z"
updated: "2001-10-02T08:49:00.000Z"
replies: 3
views: 165
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/21639-topplista"
---

# Topplista

## #1 — Andy, 2001-10-02T08:44Z

Jag har en tabell som ser ut så här:

UserID | CountryID

Permalänk: https://www.webforum.nu/p/21639

## #2 — LarsG, 2001-10-02T08:47Z

```
select countryID,count(countryID) as numberOfLusers
  from tableThatLooksLikeThis
 group by countryID
 order by 2 desc
```

Permalänk: https://www.webforum.nu/p/352684

## #3 — @nders, 2001-10-02T08:48Z

```
SELECT CountryID, COUNT(*) AS Antal FROM tblTable GROUP BY CountryID, ORDER BY Antal DESC
```

Om du använder Access så får du köra ORDER BY 2 DESC istället.

Mvh,

Permalänk: https://www.webforum.nu/p/352685

## #4 — Andy, 2001-10-02T08:49Z

Tack! Skall testa så fort jag får möjlighet...

Permalänk: https://www.webforum.nu/p/352686

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/21639-topplista