---
title: "sql count"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/77444-sql-count"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "fatcap"
published: "2003-05-19T19:41:46.000Z"
updated: "2003-05-19T19:48:38.000Z"
replies: 2
views: 238
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/77444-sql-count"
---

# sql count

## #1 — fatcap, 2003-05-19T19:41Z

hur gör jag så

```
SELECT COUNT(column) FROM table
```

skrivs ut med hjälp av asp??
skriver man 

```
<% SELECT COUNT(column) FROM table %>
```

händer ju ingenting.

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

## #2 — LarsG, 2003-05-19T19:45Z

```
sql = "SELECT COUNT(c) FROM t"
set rs = connect.execute(sql)
response.write "Antal = " & rs(0) & "<br>"
```

eller

```
sql = "SELECT COUNT(c) as f FROM t"
set rs = connect.execute(sql)
response.write "Antal = " & rs("f") & "<br>"
```

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

## #3 — fatcap, 2003-05-19T19:48Z

tackar LarsG!!

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

---

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