Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need help with SQL Statement
Message
De
23/09/1997 11:35:32
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00051219
Message ID:
00051224
Vues:
36
>Hi Vlad,
> You make an interesting observation about the # of queries apparently required with my SQL statement. I am not sure that the issue you mentioned applies to SQL however, as SQL is a non-procedural language. As I understand it, that means that the details of the implementation are determined at run time, and hidden from the developer. In general I would think that as long as the chosen SQL statement is one that was expected by the writers of the SQL implementation that the optimization process would find a sufficiently efficient way of processing the query, which would probably not match our logical model of how the query would be processed.
>
>P.S. Wasn't the initial question how to perform the query in one SQL statement?

I am not Vlad, but just to finish this discussion:
Select customer,max(date) as date,substr(max(dtoc(date,1)+allt(str(price))),9) as lastprice group by customer
So, this is one SQL combining my previous two (personally I prefer to break SQLs but if something can be broken, it might be combined by request).
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform