Using select top N clause

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Using select top N clause

Message

01/02/2008 08:15:06

31/01/2008 16:27:24

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

Network:

Windows XP

Database:

Visual FoxPro

Divers

Thread ID:

01287704

Message ID:

01287899

Vues:

Each item in the ORDER BY has a DESC option that is ascending by default, so to get what you are asking you need;

SELECT TOP 3 date,custId,notes FROM custNotes ORDER BY date DESC, custNotes DESC