Selecting TOP 5 but in reverse order

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Selecting TOP 5 but in reverse order

Message

05/07/2006 10:43:20

05/07/2006 07:23:11

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Versions des environnements

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Database:

Visual FoxPro

Divers

Thread ID:

01133722

Message ID:

01133835

Vues:

>SELECT * FROM
> (
>   SELECT TOP 5 Video.Streaming FROM Video ORDER BY Video.Streaming DESC
> ) v5 ORDER BY Streaming
>

Thanks, this approach, recommended also by two other members, is the one I an now using and it works ok.