Hello Hugo,
Is there something missing in this code? I see a semi-colon at the end of the code. Can you re-send please? Thank you again.
>>SELECT DISTINCT * FROM ACCOUNTS gives me the non dup records from my accounts table. How do I get the dups using the same command? Is there something like SELECT NOT DISTINCT * FROM ACCOUNTS?
>>
>>Any suggestions or comments will be welcome, thank you.
>
>This is one sample SQL statement I'm using in a project and works fine.
>
>Hugo
>
>===========
>SELECT DISTINCTROW First(CALLS.User_Name) AS [User_Name Field], Count(CALLS.User_Name) AS NumberOfDups
>FROM CALLS
>GROUP BY CALLS.User_Name
>HAVING (((Count(CALLS.User_Name))>1));
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