🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: dk.edb.database
Article #15080

Re: [MySQL] Select

#15080
From: Peter Brodersen
Date: Sat, 23 Jun 2001 00:29
16 lines
1436 bytes
On Sat, 23 Jun 2001 01:49:50 +0200, junk@osxhacks.com (Christian
Flintrup) wrote:

>Hvis man vil have alle de forskellige navne p� danskere, hvor dubletter
>er fjernet, hvad g�r man s�?

SELECT DISTINCT navn FROM tabel WHERE sprog = 'dansk';

Evt.:

SELECT navn FROM tabel WHERE sprog = 'dansk' GROUP BY navn;


-- 
- Pede
  Professionel n�
Technical Details
Message-ID: <klo7jtc5ncdig0k5s6cc3ocjsivi7cs0fj@news.worldonline.dk>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!news.maxwell.syr.edu!newsfeed1.uni2.dk!sunsite.dk!cyclone.sunsite.dk!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail
References: <1evflz9.1lmh3xz73a9riN%junk@osxhacks.com>

Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,2b5907e16cff19fc
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-06-22 17:31:59 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!news.maxwell.syr.edu!newsfeed1.uni2.dk!sunsite.dk!cyclone.sunsite.dk!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail
From: Peter Brodersen <professionel@nerd.dk>
Newsgroups: dk.edb.database
Subject: Re: [MySQL] Select
Message-ID: <klo7jtc5ncdig0k5s6cc3ocjsivi7cs0fj@news.worldonline.dk>
References: <1evflz9.1lmh3xz73a9riN%junk@osxhacks.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Lines: 16
Date: Sat, 23 Jun 2001 02:29:17 +0200
NNTP-Posting-Host: 213.237.11.129
X-Complaints-To: news-abuse@wol.dk
X-Trace: news000.worldonline.dk 993256056 213.237.11.129 (Sat, 23 Jun 2001 02:27:36 MET DST)
NNTP-Posting-Date: Sat, 23 Jun 2001 02:27:36 MET DST
Organization: Customer of Tiscali A/S (World Online)