SQL command: syntax needed

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQL command: syntax needed

Message

From

22/03/2004 10:37:33

All

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

SQL command: syntax needed

Miscellaneous

Thread ID:

00888526

Message ID:

00888526

Views:

I need a query to extract the most recent price inserted for a product
i.e.

id_product    year   price
1             2004   12004
1             2003   12003
2             2003   22003
2             2002   22002

so as to obtain

id_product    year   price
1             2004   12004
2             2003   22003

Which is the SQL syntax to perform the Select?
TIA