Results 1 to 1 of 1

Thread: group by help

  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    109

    Unanswered: group by help

    Hi ,
    am having a query in which i need to do a group by "hour".It displays all the data grouped in a 24 hr format and the query goes on like "group by hour(mydatabasefield)". For instance if my result set is like

    00 12
    01 12
    02 11
    03 11
    so on till 24

    I need it grouped like

    01 24
    03 22

    and so .



    How do i do this in the query ?
    Thanks in advance.
    Last edited by rexselin; 08-05-04 at 06:19.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •