---
title: "räkna inlägg"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/167123-räkna-inlägg"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Vinnaren"
published: "2007-12-10T12:08:45.000Z"
updated: "2007-12-10T12:22:26.000Z"
replies: 5
views: 358
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/167123-räkna-inlägg"
---

# räkna inlägg

## #1 — Vinnaren, 2007-12-10T12:08Z

Ska räkna hur många inlägg varje blogg har samt visa bloggnamnet på de 10 som har flest.

Har dessa två:

```
SELECT DISTINCT(b.Name) FROM blogg AS b 
INNER JOIN post AS p
ON p.bID = b.bID
ORDER BY Count(p.bID) DESC
```

 

men får felmeddelandet:
Column 'blogg.Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

Hur löser man detta??

Tacksam för all hjälp

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

## #2 — @nders, 2007-12-10T12:10Z

Tja, prova att ha med *Count(p.bID)* i select-listan?

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

## #3 — Vinnaren, 2007-12-10T12:13Z

japp, har provat det, får samma felmeddelande   :(

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

## #4 — @nders, 2007-12-10T12:14Z

Prova:

```
SELECT DISTINCT b.Name, Count(p.bID) FROM blogg AS b 
INNER JOIN post AS p
ON p.bID = b.bID
ORDER BY 2 DESC
```

edit: såklart, glömde group by - se LarsGs inlägg nedan.

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

## #5 — LarsG, 2007-12-10T12:16Z

```
SELECT  b.Name, Count(p.bID) as blogs
   FROM blogg AS b 
INNER JOIN post AS p
   ON p.bID = b.bID
  group by b.name
ORDER BY blogs desc
```

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

## #6 — Vinnaren, 2007-12-10T12:22Z

Tack   :bire , nu fungerar den   :i

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/167123-räkna-inlägg