---
title: "count(*)"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/167737-count"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "devotion"
published: "2008-01-03T09:23:54.000Z"
updated: "2008-01-03T09:42:20.000Z"
replies: 4
views: 334
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/167737-count"
---

# count(*)

## #1 — devotion, 2008-01-03T09:23Z

Hej!

Jag har följande kod:

```
select [Name], count(*) As Antal from tblUsers group by [Name] having count(*) > 1 order by [Name]
```

Fungerar fint, men hur får jag med \[Id\] Också...

Nu visas:

```
Name         Antal
-------------------
Namn 1       2
Namn 2       3
Namn 3       4
```

Jag vill visa:

```
Id        Name         Antal
-----------------------------
121657    Namn 1       2
687117    Namn 2       3
618160    Namn 3       4
```

Vad skanas i min kod?

Mvh
Henrik

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

## #2 — voigtann1, 2008-01-03T09:32Z

```
select [b][id],[/b][Name], count(*) As Antal from tblUsers group by [Name] having count(*) > 1 order by [Name]
```

?

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

## #3 — devotion, 2008-01-03T09:34Z

Jag har provat det... men då blir det fel..

> Msg 8120, Level 16, State 1, Line 3
> Column 'tblUsers.Id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Då provade jag att lägga till i GROUP BY enligt:

```
select [id],[Name], count(*) As Antal from tblUsers group by [Id],[Name] having count(*) > 1 order by [Name]
```

Men, då blirt det inga träffar alls... :(  

Mvh
Henrik

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

## #4 — inspiro, 2008-01-03T09:42Z

```
select [id],[Name], count(*) As Antal from tblUsers group by [Name] having count(*) > 1 order by [Name], [id]
```

Tror jag.

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

## #5 — Peter S, 2008-01-03T09:42Z

```
select [Name], count(*) As Antal,
 ( select top 1 id from tblusers where name = u.name ) as id
 from tblUsers u group by [Name] having count(*) > 1 order by [Name]
```

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

---

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