Tis true, I was making some assumptions I guess. And you know what they say
about that... =)
-----Original Message-----
From: Dean H. Saxe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 8:17 AM
To: SQL
Subject: RE: list once
At 08:06 AM 5/30/01 -0400, you wrote:
>Your going to have to specify at least one column name to be distinct. You
>can't have a wild card as the distinct or you will still get EVERYTHING in
>the table. I also would caution using the '*' wild card to much, you would
>be surprised at how much performance you get just by spelling out the
column
>names.
Bill,
In a normalized DB this is true, but who is to say that this DB is
normalized? If the table has duplicate records (which would mean PKs are
not being enforced or are not in place) then you will not get every record
with
SELECT DISTINCT
*
FROM
TABLE
-dhs
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
