Results 1 to 3 of 3

Thread: Distinct?

  1. #1
    Join Date
    Dec 1969

    Default Distinct?

    I am trying to distinct row 1 and 2 because firstname && lastname are similar. Any idea&#039s how to do this? Thnx!<BR><BR> firstname lastname email<BR>&#124 1&#124 bill gates billgates@microsoft.com<BR>&#124 2&#124 bill gates money@microsoft.com<BR>&#124 3&#124 bill clinton bill@whitehouse.gov<BR>&#124 4&#124 robert clinton robert@hotmail.com<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Distinct?

    Do you mean like:<BR><BR>SELECT firstname, lastname<BR>FROM RichWellKnownPeople<BR>GROUP BY firstname, lastname<BR><BR>... OR do you mean something completely different?<BR><BR>HTH<BR><BR>Darren<BR>[ darren@showusyourcode.com ]

  3. #3
    arnw Guest

    Default RE: Distinct?

    No Darren, <BR>I meant something else but i already fixed it. Thanx for your advise.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts