Re: SQL Help

Article View: borland.public.interbase.sql

Article #782

Back to borland.public.interbase.sql Previous Next

#782

From: Bill Todd
Date: Fri, 13 Jul 2007 18:29

16 lines
1344 bytes

Roy wrote:

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

Try the following and see if it works.

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


-- 
Bill Todd (TeamB)

Technical Details

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

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <46969c24@newsgroups.borland.com> <4696baa7$1@newsgroups.borland.com> <4697b4aa$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: "Bill Todd" <no@no.com>
Subject: Re: SQL Help
Newsgroups: borland.public.interbase.sql
References: <46969c24@newsgroups.borland.com> <4696baa7$1@newsgroups.borland.com> <4697b4aa$1@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <4697c494$1@newsgroups.borland.com>
Date: 13 Jul 2007 11:29:40 -0700
X-Trace: newsgroups.borland.com 1184351380 216.207.211.19 (13 Jul 2007 11:29:40 -0700)
Lines: 16
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message