Select top 2 returns more than 2

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Select top 2 returns more than 2

Message

From

03/02/2011 05:54:22

All

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Select top 2 returns more than 2

Miscellaneous

Thread ID:

01498480

Message ID:

01498480

Views:

110

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