---
title: "distinct, recent ??"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/113368-distinct-recent"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Gimbo"
published: "2004-10-11T17:27:48.000Z"
updated: "2004-10-12T07:09:08.000Z"
replies: 1
views: 194
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/113368-distinct-recent"
---

# distinct, recent ??

## #1 — Gimbo, 2004-10-11T17:27Z

hejsan har en sql som ser ut pa foljande:

```
SELECT DISTINCT 
                      ccStatus.orderID AS orderID, ccStatus.OrderStatus AS orderStatus, orders.fName AS fName, orders.lName AS lName, 
                      orders.Time_stamp AS time_stamp
FROM         orders INNER JOIN
                      ccStatus ON orders.ID = ccStatus.orderID
ORDER BY ccStatus.time_stamp DESC
```

i denna relation kan det dyka up dubletter pa orderID i ccStatus tabellen vilket medfor att nar jag listar ut innehallet sa visas dubletterna, jag vill endast lista ut, den senaste orderID'et och endast en av de inte alla... distinct funkar inte i min relation just nu?? ngn som vet hur?

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

## #2 — LarsG, 2004-10-12T07:09Z

```
SELECT 
ccStatus.orderID, 
ccStatus.OrderStatus, 
orders.fName, 
orders.lName, 
max(orders.Time_stamp) AS time_stamp
FROM         orders INNER JOIN
ccStatus ON orders.ID = ccStatus.orderID
group by ccStatus.orderID, 
ccStatus.OrderStatus, 
orders.fName, 
orders.lName
ORDER BY time_stamp DESC
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/113368-distinct-recent