query for displaying non distinct entries



hi all,

i want a sql stmt for displaying the total records in a table having the
multiple copies of a particular field say email .

so i want to display those records having same email in more than one
entries.

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: query for displaying non distinct entries
    ... SQL Server MVP ... i want a sql stmt for displaying the total records in a table having the ...
    (microsoft.public.sqlserver.mseq)
  • Re: query for displaying non distinct entries
    ... Another solution, if the table has a primary key column, that would let you see the full rows is ... i want a sql stmt for displaying the total records in a table having the ...
    (microsoft.public.sqlserver.mseq)
  • Re: Linking form to multiple tables
    ... "Jeff Boyce" wrote: ... It isn't clear from your description whether you table with "multiple ... More specific description of your data structure (it all starts with the ... I need a method of displaying the questions on a form and being able to ...
    (microsoft.public.access.forms)
  • Re: Parameter query does not show all data in memo fields with vbcrlf
    ... How are you displaying the ... have you made the control large enough to display multiple lines? ... The results from above query do not show all names in memo fields that are ...
    (microsoft.public.access.queries)
  • Problem with multiple lines in db data
    ... "HEY ... "HEY THIS IS A TEST OF MULTIPLE LINES" ... Some of the settings on the textbox displaying the datafield on one row (I ... Any suggestions to what I should do to get this datafield displaying the ...
    (microsoft.public.dotnet.framework.aspnet)