---
title: "Snabb sql"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/80930-snabb-sql"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Ceeron"
published: "2003-06-30T17:52:26.000Z"
updated: "2003-06-30T18:48:41.000Z"
replies: 4
views: 220
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/80930-snabb-sql"
---

# Snabb sql

## #1 — Ceeron, 2003-06-30T17:52Z

```
sql = "select count(*) as besokare from raknare, count(distinct ip) as unika from raknare"
```

asså vill ha: count(\*) as besokare
o sen: unika som alla unika ip...

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

## #2 — LarsG, 2003-06-30T18:00Z

```
select count(*) as besokare,
          count(distinct ip) as unika 
  from raknare
```

flyttas från ASP.

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

## #3 — Ceeron, 2003-06-30T18:04Z

```
select count(*) as besokare, count(distinct IP) as unika from raknare
```

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
\[Microsoft\]\[Drivrutin för ODBC Microsoft Access\] Syntaxfel (operator saknas) i frågeuttrycket 'count(distinct IP)'.
/alkisarna/Default.asp, line 679

kör access alltså ;)

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

## #4 — LarsG, 2003-06-30T18:08Z

Ja Access har en begränsning här

```
select count(*) as besokare, 
(select count(*) from
 (select distinct ip from raknare)) as unika 
from raknare
```

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

## #5 — Ceeron, 2003-06-30T18:48Z

Tackar vi för
Funkar prima

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

---

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