---
title: "distinct"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/53584-distinct/page2"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Bjuris"
published: "2002-09-18T06:12:28.000Z"
updated: "2002-10-08T08:12:55.000Z"
replies: 20
views: 392
page: 2
pages: 2
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/53584-distinct"
---

# distinct

_Sida 2 av 2._

## #21 — Bjuris, 2002-10-08T08:12Z

Jag har löst det med denna SQL fråga:

```
select stats.flight, stats.date, max(stats.kgs), stats.awb from stats, 
(select flight as test1 from capacity where date='01JUL' and route='GLA LHR') as test2 
where test1=stats.flight AND stats.date='01JUL' group by stats.awb, stats.date, stats.flight 
order by stats.flight, stats.date, stats.awb
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/53584-distinct/page2  
Föregående sida: https://www.webforum.nu/amne/databaser-sql/53584-distinct.md