Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL question #2
Message
De
06/08/2009 07:21:10
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
06/08/2009 07:01:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Divers
Thread ID:
01416409
Message ID:
01416418
Vues:
46
>count(*) && just counting the number of records anyway

Yes, this is true.

Thank you for the help

Agnes

>Good Agnes, better than mine
>
>
>you can change
>COUNT(c1 + c2 )
>
>into 
>
>count(*)  && just counting the number of records anyway
>
>
>
>
>>Grgory,
>>
>>what do you think about
>>
>>DELETE FROM Schnaps;
>> WHERE i1 IN ;
>> (;
>>  SELECT S.i1 ;
>>   FROM Schnaps AS S;
>>   INNER JOIN;
>>    ( ;
>>    SELECT c3, MIN(i1) AS i1;
>>     FROM Schnaps ;
>>     GROUP BY  1 ;
>>     HAVING ( COUNT(c1 + c2 ) > 1) ;
>>    ) AS AA ;
>>   ON S.c3 == AA.c3;
>>   AND S.i1>AA.i1;
>> )
>>
>>
>>?
>>
>>Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform