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));
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only