---
title: "Distinct key"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/161335-distinct-key"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Dino"
published: "2007-06-10T19:59:39.000Z"
updated: "2007-06-11T16:16:15.000Z"
replies: 1
views: 347
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/161335-distinct-key"
---

# Distinct key

## #1 — Dino, 2007-06-10T19:59Z

MSSql 2005

Har en tabell med massa nycklar som följande:

Key
\----------------
page_setting_l1
page_setting_l2
page_setting_l3
page_setting_l4
page_setting_l5
page_track_l1
page_track_l2
page_track_l3
group_address_l1
group_address_l2
group_address_l3
group_address_l4
page_a_track_l1
page_a_track_l2
page_list_l1
page_list_l2
page_list_l3

Söker en SELECT som kan ta ut distinct med följande resultat:
Result
\--------
page_setting
page_track
group_address
page_a_track
page_list

/Tack

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

## #2 — Peter S, 2007-06-11T16:16Z

```
select distinct
    substring(key, 1, patindex('%[1-9]%', key) - 3)
```

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

---

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