Information générale
Catégorie:
Codage, syntaxe et commandes
>>
>>SELECT * FROM Quotes WHERE ;
>> DTOC(Date)+Customer IN ;
>> (SELECT MAX(DTOC(Date))+Customer FROM Quotes)
>
>Yes, but you still have two SQL-SELECTs (even if one is embeded). Still, yours should be faster than 2 separate SELECTs.
>
I left off the GROUP BY in the above statement. Sorry. It was late. I'll use that as an excuse.
Anyway it should have been
>SELECT * FROM Quotes WHERE ;
> DTOC(Date)+Customer IN ;
> (SELECT MAX(DTOC(Date))+Customer FROM Quotes GROUP BY Customer)
I don't know about the speed of nested selects vs. seperate selects.
But as you said I think the single statment would be faster.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement