On Tue, 16 Nov 2004, Thomas F.O'Connell wrote: > I am wondering whether the following two forms of SELECT statements are > logically equivalent: > > SELECT COUNT( DISTINCT table.column ) ... > > and > > SELECT DISTINCT COUNT( * ) ...
Not in general. The former counts how many distinct table.column values there are. The distinct in the latter would be basically meaningless unless there's a group by involved. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
