Alias kolumny w MapInfo

Thread View: pl.comp.gis

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by takeshin Wed, 06 May 2009 13:24

#11937

Author: 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

Re: Alias kolumny w MapInfo

#11938

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads