Transform en SQL

Article View: es.comp.os.linux.programacion

Article #12060

Back to es.comp.os.linux.programacion Previous Next

#12060

From: Xavier Montero
Date: Sun, 02 Sep 2001 11:52

15 lines
1302 bytes

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?
Alguien sabe si esa sentencia es ANSI SQL o es un invento de Access?

Saludos
Xavi.
-- 
Xavier Montero - Digital Sound Items, scp
Tel: 93 589 71 91 - Fax: 93 590 10 96 - Cell: 630 59 01 62
www.dsitelecom.com - xmontero@dsitelecom.com

Technical Details

Message-ID: <3B921D9B.BB883904@dsitelecom.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!130.133.1.3!fu-berlin.de!newsfeed.bcn.ttd.net!news.bcn.ttd.net!frodo.audiolis.com!127.0.0.1!news.antakira.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: SPANISH,ASCII
X-Google-Thread: f86c8,16d9657e1a201eb4,start
X-Google-Attributes: gidf86c8,public
X-Google-ArrivalTime: 2001-09-02 05:02:46 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!130.133.1.3!fu-berlin.de!newsfeed.bcn.ttd.net!news.bcn.ttd.net!frodo.audiolis.com!127.0.0.1!news.antakira.com!not-for-mail
From: Xavier Montero <xmontero@dsitelecom.com>
Newsgroups: es.comp.os.linux.programacion
Subject: Transform en SQL
Date: Sun, 02 Sep 2001 13:52:59 +0200
Organization: Digital Sound Items
Lines: 15
Message-ID: <3B921D9B.BB883904@dsitelecom.com>
NNTP-Posting-Host: 213.97.227.24
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Mailer: Mozilla 4.77 [en] (Windows NT 5.0; U)
X-Accept-Language: en