List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 9 2003 5:41pm
View as plain text  
At 7:54 -0800 1/9/03, squeebee@stripped wrote:
>Hey all;
>I am trying to work on a query that has SELECT DISTINCT * ..........
>This does not work. While there is no error, the where clause causes 
>repeats. I
>do not really expect this to work, as DISTINCT needs a column to work with.

No, it doesn't.   SELECT DISTINCT * should remove duplicates.

>  I
>am trying to avoid the workaround of putting in every column from the table in
>the select statement, so does anyone have any idea on how to keep the same row
>from coming up twice while still being able to use SELECT * ??
>Mike Hillyer

SELECT DISTINCT *squeebee9 Jan
  • Re: SELECT DISTINCT *Paul DuBois9 Jan
  • Re: SELECT DISTINCT *gerald_clark9 Jan