---
title: "DATEDIFF och GROUP BY"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/21915-datediff-och-group-by"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "kristoffer"
published: "2002-01-30T15:15:00.000Z"
updated: "2002-01-30T16:04:00.000Z"
replies: 2
views: 241
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/21915-datediff-och-group-by"
---

# DATEDIFF och GROUP BY

## #1 — kristoffer, 2002-01-30T15:15Z

Jag vill visa hur lång tid varje person (log_userID) har varit inloggad totalt. Jag sparar bland annat  logLogindate, logLogoutdate och log_userId i tabellen. Detta fungerar inte:

```
SELECT log_userId, DATEDIFF(minute, logLogindate, logLogoutdate)
FROM login
GROUP BY log_userId
```

```
Column login.logLogoutdate is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
```

DBMS = SQL Server

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

## #2 — LarsG, 2002-01-30T15:20Z

```
SELECT log_userId, sum(DATEDIFF(minute, logLogindate, logLogoutdate))
FROM login
GROUP BY log_userId
```

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

## #3 — kristoffer, 2002-01-30T16:04Z

Tackar.

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/21915-datediff-och-group-by