Select top 2 returns more than 2

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Select top 2 returns more than 2

Message

03/02/2011 05:54:22

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Select top 2 returns more than 2

Divers

Thread ID:

01498480

Message ID:

01498480

Vues:

112

I have following command:
SELECT TOP 2 REP FROM MyTable ORDER BY REP

However this returns 6 records.
I was expecting just 2.
Tia
Gerard