Re: distinct with all the columns

Something else.

If you had used a 'real' email address, instead of being so clever, I would
have sent your responce directly to you and you would have saved some time.

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam


"Philippe" <Philippe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:39341A08-7912-4DB0-85FD-940F51BD8C40@xxxxxxxxxxxxxxxx
Hi,

I've got something, but I can't get all of my columns shown. I've got a
table with a few columns and in one columns there are records with
duplicate
values, so I use a distinct to get all the duplicates out of the result
set,
but this only works for 1 column, I also want to show the other columns of
that record that was filtered by the distinct clause, but this doesn't
work.

Any suggestions?

thanks


.

Relevant Pages

  • Re: Santana/Haren P
    ... dice gladly that Buchholz is able to duplicate that. ... I doubt that Buchholz will win 30 games next season. ... I'm sure it seemed clever ...
    (alt.sports.baseball.bos-redsox)
  • Re: Santana/Haren P
    ... dice gladly that Buchholz is able to duplicate that. ... I doubt that Buchholz will win 30 games next season. ... I'm sure it seemed clever ... non-native speaker to realise the question should be "repeat", ...
    (alt.sports.baseball.bos-redsox)
  • Re: distinct with all the columns
    ... Without having your table schema DDL, and some sample data, it is difficult to 'guess' the nature of your issue. ... However, using my weegee board -yes, that is how My weegee board is spelled! ... The same goes for any combinations, starting from the rightmost listed column, where the columns have duplicate values. ... that record that was filtered by the distinct clause, ...
    (microsoft.public.sqlserver.mseq)