SQL -- getting hourly averages of 15 minute bars

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SQL -- getting hourly averages of 15 minute bars

Message

06/02/2014 11:23:04

06/02/2014 11:04:48

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Windows 7

Network:

Windows 2008 Server

Database:

Visual FoxPro

Application:

Desktop

Divers

Thread ID:

01593485

Message ID:

01593492

Vues:

Thanks. I tried this. The name of my table is in fact ratings

select [hour], avg(mRating) as AvgRating from Ratings GROUP BY [hour]

But I don't get an average for every hour, instead I got an average for the entire table, in other words a table with a single record?

exp_1     AvgRating
hour       3.64

Have any ideas?
Thanks
Steve