---
title: "SELECT DISTINCT COUNT(*) Access"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/135966-select-distinct-count-access"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Fraggel"
published: "2005-10-18T20:56:01.000Z"
updated: "2005-10-18T21:08:15.000Z"
replies: 1
views: 318
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/135966-select-distinct-count-access"
---

# SELECT DISTINCT COUNT(*) Access

## #1 — Fraggel, 2005-10-18T20:56Z

SELECT DISTINCT(gameID) FROM gameScore WHERE playerID=41 OR playerID=11;

Hur får jag in en count() i denna SQL sats

SELECT count(DISTINCT(gameID)) FROM gameScore WHERE playerID=41 OR playerID=11;

Är inte funkis i Access ialla fall  :q

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

## #2 — m_soderlund, 2005-10-18T21:08Z

```
SELECT count(*) FROM (SELECT distinct gameID FROM gameScore WHERE playerID=41 OR playerID=11)
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/135966-select-distinct-count-access