Ahhhh ... Oracle database ... SQL question ... what does this have to do with DotNetDevelopment exactly?
∞ Andy Badera ∞ +1 518-641-1280 ∞ This email is: [ ] bloggable [x] ask first [ ] private ∞ Google me: http://www.google.com/search?q=andrew%20badera On Wed, Sep 23, 2009 at 6:35 AM, Pratiksha Saxena <[email protected]> wrote: > I am using Oracle Database which has two column lastupdate date,lastvalue > number. > lastupdate is date which has time also .i wanted grouping on hour so i wrote > SELECT TO_CHAR(LASTUPDATE,'mm/dd/yyyy hh') lastupdate,lastvalue FROM > intradaydata > where securities='IB Equity' GROUP BY TO_CHAR(LASTUPDATE,'mm/dd/yyyy > hh'),lastvalue > This gives me > Lastupdate Lastvalue > 08/27/2009 10 163.8 > 08/27/2009 10 168.5 > 08/27/2009 10 167.8 > 08/27/2009 10 163.7 > 08/27/2009 10 163.8 > 08/27/2009 09 168.5 > 08/27/2009 09 167.8 > 08/27/2009 09 163.7 > > I want this(maybe sum or avg on lastvalue) > Lastupdate Lastvalue > 08/27/2009 10 163.8 > 08/27/2009 09 163.8 > > Please help. > > > > > > >
