Article View: es.comp.os.linux.programacion
Article #12066Re: Transform en SQL
From: DaVinci
Date: Sun, 02 Sep 2001 16:20
Date: Sun, 02 Sep 2001 16:20
21 lines
1573 bytes
1573 bytes
In article <3B921D9B.BB883904@dsitelecom.com>, Xavier Montero wrote: > Sea S la sentencia SQL: > > TRANSFORM Max([MiTabla].Value) AS [El Valor] SELECT > [MiTabla].ID FROM [MiTabla] GROUP BY [MiTabla].ID > PIVOT [MiTabla].Property > > Alguien sabe si S es v�lido en MySQL o Postgress? En PG no. En MySql no lo s�. > Alguien sabe si esa sentencia es ANSI SQL o es un invento de Access? Por lo que yo s�, eso no es SQL. �Qu� hace exactamente la orden?. Saludos. -- David Espada, a.k.a. |)a\/inci (davinci@escomposlinux.org) Debian GNU/Linux Sid
Technical Details
Message-ID:
<slrn9p4n4j.c6.david@lorien.net>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!193.251.151.101!opentransit.net!newsfeed.comtenidos.com!newsfeeder.wanadoo.es!news.antakira.com!not-for-mailReferences:
<3B921D9B.BB883904@dsitelecom.com>Show Full Headers
Complete Article Headers
X-Google-Language: SPANISH,ASCII X-Google-Thread: f86c8,16d9657e1a201eb4 X-Google-Attributes: gidf86c8,public X-Google-ArrivalTime: 2001-09-02 10:06:04 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!193.251.151.101!opentransit.net!newsfeed.comtenidos.com!newsfeeder.wanadoo.es!news.antakira.com!not-for-mail From: DaVinci <david@lorien.net> Newsgroups: es.comp.os.linux.programacion Subject: Re: Transform en SQL Date: 2 Sep 2001 16:20:54 GMT Organization: Seelie court Lines: 21 Message-ID: <slrn9p4n4j.c6.david@lorien.net> References: <3B921D9B.BB883904@dsitelecom.com> NNTP-Posting-Host: 212.25.147.135 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.wanadoo.es 999450137 21542 212.25.147.135 (2 Sep 2001 17:02:17 GMT) X-Complaints-To: usenet@wanadoo.es NNTP-Posting-Date: Sun, 2 Sep 2001 17:02:17 +0000 (UTC) User-Agent: slrn/0.9.7.2 (Linux)