Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting TOP 5 but in reverse order
Message
 
To
05/07/2006 00:30:19
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Selecting TOP 5 but in reverse order
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01133722
Message ID:
01133732
Views:
13
Hi Michel,

Could be this?

SELECT x.Stream from (SELECT TOP 5 Video.Streaming FROM Video ORDER BY Video.Streaming DESC) x ORDER BY x.Stream

Regards,

Oscar Zarate,
National Australia Bank
Oscar Zarate
National Australia Bank
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform