Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT TOP 50 behavior
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00021472
Message ID:
00021524
Views:
50
>Some other field to break ties. You could order by messages and name, that way you'll get exactly 50 records unless names are identical. Or you could use a date, something less arbitrary. Anything that makes sense so that you can have the SQL order the tied records so that they aren't tied any more. I do that in my ranking queries to get an exact number.

Thanks, I'll plug the ID field.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform