🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: pl.comp.gis
Article #11937

Alias kolumny w MapInfo

#11937
From: takeshin
Date: Wed, 06 May 2009 13:24
13 lines
1416 bytes
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: <44187a21-68e6-4dd7-b8c9-fd2a898af4eb@z5g2000vba.googlegroups.com>
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.glorb.com!news2.glorb.com!postnews.google.com!z5g2000vba.googlegroups.com!not-for-mail

Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.glorb.com!news2.glorb.com!postnews.google.com!z5g2000vba.googlegroups.com!not-for-mail
From: takeshin <admirau@gmail.com>
Newsgroups: pl.comp.gis
Subject: Alias kolumny w MapInfo
Date: Wed, 6 May 2009 06:24:44 -0700 (PDT)
Organization: http://groups.google.com
Lines: 13
Message-ID: <44187a21-68e6-4dd7-b8c9-fd2a898af4eb@z5g2000vba.googlegroups.com>
NNTP-Posting-Host: 89.107.158.132
Mime-Version: 1.0
X-Trace: posting.google.com 1241616284 22001 127.0.0.1 (6 May 2009 13:24:44 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 6 May 2009 13:24:44 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: z5g2000vba.googlegroups.com; posting-host=89.107.158.132;  posting-account=qgHQ1AoAAACgZAdk2wI3bCHUifWDtCWi
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; pl; rv:1.9.0.7)  Gecko/2009021910 Firefox/3.0.7 (.NET CLR 3.5.30729) FirePHP/0.2.4,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 wangate.silesia-region.pl:800 (squid/2.6.STABLE21)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit