Re: Sortering efter alfabetet

Article View: dk.edb.database

Article #15136

#15136

From: Jonas Delfs
Date: Sat, 14 Jul 2001 16:10

18 lines
1500 bytes

"Ren� Holmkvist Pedersen" <RHP@newcon.dk> skrev i en meddelelse
news:9im3i7$ng9$1@sunsite.dk...

> Jeg har en MS SQL server og her en problem med at sortere kollonerne.
>
> sqlstr= "CREATE TABEL NyTabel (Unit text, Unitname text, Path text)
>
> Jeg vil gerne f�rste sortere(alfabetisk) efter Unit, derefter efter
Unitname
> og tilsidst Path.

SELECT * FROM <tbl> ORDER BY Unit, Unitname, Path

?

--
Mvh. Jonas Delfs, http://delfs.dk
e72bd3e51a7937c87d28b85d677a97b2

Technical Details

Message-ID: <9ipqq4$g6$1@sunsite.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!skynet.be!newsfeed1.uni2.dk!sunsite.dk!not-for-mail

References: <9im3i7$ng9$1@sunsite.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,8b8262499984d9be
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-14 09:16:50 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!skynet.be!newsfeed1.uni2.dk!sunsite.dk!not-for-mail
From: "Jonas Delfs" <jonas@nospam.delfs.dk>
Newsgroups: dk.edb.database
Subject: Re: Sortering efter alfabetet
Date: Sat, 14 Jul 2001 18:10:52 +0200
Organization: SunSITE.dk - Supporting Opensource Software
Lines: 20
Sender: jonas@131.165.143.165
Message-ID: <9ipqq4$g6$1@sunsite.dk>
References: <9im3i7$ng9$1@sunsite.dk>
NNTP-Posting-Host: 131.165.143.165
X-Trace: sunsite.dk 995126916 518 131.165.143.165 (14 Jul 2001 16:08:36 GMT)
X-Complaints-To: news@sunsite.dk
NNTP-Posting-Date: Sat, 14 Jul 2001 16:08:36 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-Authenticated: jonas@delfs.dk

Reply to Parent Message