---
title: "select max"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/40465-select-max"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "sven"
published: "2002-03-28T11:57:39.000Z"
updated: "2002-03-28T12:36:27.000Z"
replies: 6
views: 204
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/asp/40465-select-max"
---

# select max

## #1 — sven, 2002-03-28T11:57Z

Om jag vill välja den största posten typ...

```
SQL = "SELECT MAX(askadare) AS askad FROM match WHERE typ = 'traning' AND hlag = 'Albinoleffe'"
```

 
så funkar det bra...
Men om jag vill ha ut alla andra kolumner hur gör jag då?

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

## #2 — Web-Tor, 2002-03-28T12:12Z

```
SQL = "SELECT kolumn1, kolumn2, kolumn3, MAX(askadare) AS askad FROM match WHERE typ = 'traning' AND hlag = 'Albinoleffe'"
```

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

## #3 — sven, 2002-03-28T12:18Z

Provade det... då fick jag felmeddelande
You tried to execute a query that does not include the specified expression 'datum' as part of an aggregate function. 

Hmmm???

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

## #4 — @nders, 2002-03-28T12:26Z

Hur ser SQL-frågan ut nu?

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

## #5 — LarsG, 2002-03-28T12:28Z

```
QL = "SELECT kolumn1, kolumn2, kolumn3, askadare " &_
" FROM match where askadare in ( select max(askadare) " &_
" from match WHERE typ = 'traning' AND hlag = 'Albinoleffe')"
```

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

## #6 — sven, 2002-03-28T12:29Z

typ så här..

```
SQL = "SELECT datum, hlag, blag, hmal, bmal, MAX(askadare) AS askad FROM match WHERE typ = 'traning' AND hlag = 'Albinoleffe'"
```

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

## #7 — sven, 2002-03-28T12:36Z

Tackar och bugar.... var krångligare än jag trodde...

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/40465-select-max