PDA

Click to See Complete Forum and Search --> : SQL QUERY with 5min avg.

malay_biswal
11-22-2005, 01:44 PM
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.
sunil_kandi
11-23-2005, 02:22 AM
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
tamilselvan
11-23-2005, 01:40 PM
Read this:
http://www.dbasupport.com/forums/showthread.php?t=49483

Tamil