Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT TOP 50 behavior
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00021472
Message ID:
00021524
Vues:
54
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform