Re: SQL Help

Article View: borland.public.interbase.sql

Article #781

Back to borland.public.interbase.sql Previous Next

#781

From: Roy
Date: Fri, 13 Jul 2007 17:17

25 lines
1820 bytes

Hi,

These are the fields and types and the corrected statement. Sorry.

> START_DATETIME : TIMESTAMP
> TRAFFIC :FLOAT
> ROUTE_NAME :CHAR(10)


> SELECT START_DATETIME,ROUTE_NAME, MAX(TRAFFIC) from SYSTRAFFIC where
> START_DATETIME  BETWEEN '2007/1/1 00:00' AND '2007/1/1 23:00'  GROUP BY
> START_DATETIME,ROUTE_NAME


"Bill Todd" <no@no.com> wrote in message 
news:4696baa7$1@newsgroups.borland.com...
> You are not grouping by the date. You are grouping by the date and time
> assuming that START_DATETIME is a TIMESTAMP field. Also you claim that
> the table contains a column named START_DATETIME but your SELECT refers
> to a field named START_DATE and you claim the SQL runs. How is that
> possible? It would really help if you would show us the actual fields
> with their data types and and an SQL statement that actually runs.
>
> -- 
> Bill Todd (TeamB)

Technical Details

Message-ID: <4697b4aa$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed.kamp.net!newsfeed.kamp.net!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <46969c24@newsgroups.borland.com> <4696baa7$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,8f88f6177bf0b125
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Roy" <butcherr@candw.lc>
Newsgroups: borland.public.interbase.sql
References:  <46969c24@newsgroups.borland.com> <4696baa7$1@newsgroups.borland.com>
Subject: Re: SQL Help
Date: Fri, 13 Jul 2007 12:17:04 -0500
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 200.2.131.50
Message-ID: <4697b4aa$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1184347306 200.2.131.50 (13 Jul 2007 10:21:46 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed.kamp.net!newsfeed.kamp.net!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message