---
title: "räkna kommentarer"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/167673-räkna-kommentarer"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Vinnaren"
published: "2007-12-30T20:20:47.000Z"
updated: "2007-12-30T21:14:26.000Z"
replies: 2
views: 383
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/167673-räkna-kommentarer"
---

# räkna kommentarer

## #1 — Vinnaren, 2007-12-30T20:20Z

Har följande:

```
	SELECT TOP (@Posts) p.postID, 
	ISNULL(p.cID, 0) AS 'cID',
	p.Header, 
	p.Text, p.bID,
	ISNULL(c.Name, 'Saknas') AS 'categoryName',	
	CONVERT(VARCHAR(17), p.Date, 113) AS date,
	ISNULL(u.UserName, 'Avregistrerad') AS 'UserName',	
	COUNT(com.comID) AS numberOfComment
	FROM post AS p
	LEFT OUTER JOIN category AS c
	ON p.cID = c.cID
	LEFT OUTER JOIN aspnet_Users AS u
	ON p.UserId = u.UserId
	LEFT OUTER JOIN comment AS com
	ON com.postID = p.postID
	WHERE p.bID = @bloggID 
             AND p.Status = 1
	ORDER BY p.Date DESC
```

Får felmeddelandet:
Column 'post.postID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Hur får man till det med GROUP BY??

Tacksam för all hjälp   :stud

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

## #2 — doggelito, 2007-12-30T21:07Z

Det känns fel med en join där för att bara få fram antalet kommentarer.
En subselect skulle passa bättre!
Sen behöver du inte ha apostrofer på dina aliasnamn.

```
SELECT TOP (@Posts) p.postID, 
	ISNULL(p.cID, 0) AS cID,
	p.Header, 
	p.Text, p.bID,
	ISNULL(c.Name, 'Saknas') AS categoryName,	
	CONVERT(VARCHAR(17), p.Date, 113) AS date,
	ISNULL(u.UserName, 'Avregistrerad') AS UserName,	
	(SELECT COUNT(*) FROM comment AS com WHERE p.postID = com.postID) AS numberOfComment
FROM post AS p
LEFT OUTER JOIN category AS c ON p.cID = c.cID
LEFT OUTER JOIN aspnet_Users AS u ON p.UserId = u.UserId
WHERE p.bID = @bloggID 
	AND p.Status = 1
ORDER BY p.Date DESC
```

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

## #3 — Vinnaren, 2007-12-30T21:14Z

Tusen tack doggelito, fungerade perfekt   :bire

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/167673-räkna-kommentarer