Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
UNION SELECT... please correct me
Message
De
31/10/1998 11:31:32
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
30/10/1998 18:52:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00150818
Message ID:
00153174
Vues:
23
>Assuming you have unique prices...
>
>Vlad
>
>>For performance gain I think I would first do two seek() on the price, with set near on and once with ascending tag then descending tag, get the two price values, then execute one SQL using between.
>>Cetin
No not assuming. If assumed like that, then would just scatter the two records :) I think TOP approach assumes it.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform