🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: pl.comp.gis
Article #11938

Re: Alias kolumny w MapInfo

#11938
From: Karol Stachura
Date: Mon, 11 May 2009 18:52
25 lines
1437 bytes
Witam,
select sum(Area(obj, "sq m")) "K", pole2 from dane group by pole2 order by 
"K"
Pozdrawiam,
Karol Stachura





Użytkownik "takeshin" <admirau@gmail.com> napisał w wiadomości 
news:44187a21-68e6-4dd7-b8c9-fd2a898af4eb@z5g2000vba.googlegroups.com...
Witam!

Jak w MapInfo zrobić zapytanie zawierające alias kolumny?
Potrzebne mi coś w rodzaju:

select kolumna as K from dane order by K desc

a dokładnie:

select sum(area(pole)) as K, pole2 from dane group by pole2 order by K

--
takeshin 
Technical Details
Message-ID: <gu9s5o$suo$1@news.onet.pl>
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.onet.pl!not-for-mail
References: <44187a21-68e6-4dd7-b8c9-fd2a898af4eb@z5g2000vba.googlegroups.com>

Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.onet.pl!not-for-mail
From: "Karol Stachura" <kstachura@poczta.onet.pl>
Newsgroups: pl.comp.gis
Subject: Re: Alias kolumny w MapInfo
Date: Mon, 11 May 2009 20:52:46 +0200
Organization: http://onet.pl
Lines: 27
Message-ID: <gu9s5o$suo$1@news.onet.pl>
References: <44187a21-68e6-4dd7-b8c9-fd2a898af4eb@z5g2000vba.googlegroups.com>
NNTP-Posting-Host: apn-77-112-212-16.dynamic.gprs.plus.pl
X-Trace: news.onet.pl 1242067961 29656 77.112.212.16 (11 May 2009 18:52:41 GMT)
X-Complaints-To: niusy@onet.pl
NNTP-Posting-Date: Mon, 11 May 2009 18:52:41 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit