SQL Grouped By Two Parts of Date - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQL Grouped By Two Parts of Date

Message

From

26/02/2010 10:36:04

Jerry Kahn
New York City, New York, United States

To

26/02/2010 08:18:33

Steven Dyke
Safran Seats USA
Texas, United States

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Re: SQL Grouped By Two Parts of Date

Environment versions

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP

Network:

Windows 2008 Server

Database:

Visual FoxPro

Application:

Desktop

Miscellaneous

Thread ID:

01451199

Message ID:

01451247

Views:

28

Select nYear, nMonth, Sum(F1), Sum(F2) From TableName Group By nYear, nMonth

Click here to load this message in the networking platform