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
