SQL QUERY with 5min avg.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SQL QUERY with 5min avg.

  1. #1
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349

    Arrow SQL QUERY with 5min avg.

    I've one table with these 3 columns.

    LOGDATE ZONE NUMBER
    -------------------------------- --------- ---------
    "10/24/2005 10:21:15.303000 AM";"SPAFTER";0
    "10/24/2005 10:21:16.663000 AM";"SPAFTER";0
    "10/24/2005 10:21:16.722000 AM";"SPAFTER";1
    "10/24/2005 10:21:16.740000 AM";"SPAFTER";2
    "10/24/2005 10:21:16.749000 AM";"SPAFTER";3
    "10/24/2005 10:21:17.589000 AM";"SPAFTER";4
    "10/24/2005 10:21:17.596000 AM";"SPAFTER";5
    "10/24/2005 10:21:18.480000 AM";"SPAFTER";5
    "10/24/2005 10:21:19.053000 AM";"SPAFTER";5
    ......
    "10/24/2005 11:27:19.053000 AM";"SPAFTER";51

    Need to right one sql which will give me the average of number for 5 minutes duration.
    http://www.perf-engg.com
    A performance engineering forum

  2. #2
    Join Date
    Nov 2005
    Location
    USA
    Posts
    32
    Quote Originally Posted by malay_biswal
    I've one table with these 3 columns.
    Need to right one sql which will give me the average of number for 5 minutes duration.
    You need to elaborate more on this.. It is difficult to understand the requirement

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135

Posting Permissions

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


Click Here to Expand Forum to Full Width