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!

You could use GROUP BY. (A bit heavy-handed, but hey, it works!)

SELECT
Column1
, Column2
, Column3
, Column4
FROM MyTable
WHERE (Criteria here)
GROUP BY
Column1
, Column2
, Column3
, Column4

If Column4 has multiple entries (all others being the same) there will be only 1 row in the resultset. The same goes for any combinations, starting from the rightmost listed column, where the columns have duplicate values.

This should work, and there may be other suggestions coming
--
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