Re: need advice about sql for data mining

Article View: borland.public.interbase.sql

Article #206

Back to borland.public.interbase.sql Previous Next

#206

From: Isaac
Date: Tue, 10 Jun 2008 16:55

32 lines
1456 bytes

Craig Stuntz [TeamB] wrote:
> Maxim Shiryaev wrote:
>
>   
>>   select date
>>     from purchase
>>
>>     union all
>>
>>     select date
>>     from sales
>>
>>     group by 1
>>     
>
> 	This isn't valid InterBase SQL.
>
> Instead, do:
>
> SELECT DISTINCT
>   date
> FROM
>   purchase
> UNION 
> SELECT DISTINCT
>   date
> FROM
>   sales
> INTO ...
>
>   
Thanks

Technical Details

Message-ID: <484eb159@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <484db5e2@newsgroups.borland.com> <484e2f00$1@newsgroups.borland.com> <484e805a$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,b4be59b23378bfae
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 10 Jun 2008 19:55:40 +0300
From: Isaac <no@no.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: need advice about sql for data mining
References: <484db5e2@newsgroups.borland.com> <484e2f00$1@newsgroups.borland.com> <484e805a$1@newsgroups.borland.com>
In-Reply-To: <484e805a$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 41.234.200.177
Message-ID: <484eb159@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1213116761 41.234.200.177 (10 Jun 2008 09:52:41 -0700)
Lines: 32
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message