RE: [QUESTIONS] COUNT (DISTINCT xxx) ?
Started by Jackson, DeJuanover 27 years ago1 messages
Hi!
Is there a way excluding temp tables to make a COUNT (DISTINCT xxx)
query?Thanx for the attention!
Marin
I'd like to know as well. I think that someone was trying to implement
sub-selects in aggregate functions, did that get done?
select distinct count(col_name) from table_name;
doesn't work BTW, it gives that number of rows in the table even if
col_name has duplicates.
-DEJ