[b][red]This message was edited by BJ008 at 2004-11-4 11:58:0[/red][/b][hr]
[b][red]This message was edited by BJ008 at 2004-11-4 11:28:47[/red][/b][hr]
I have table with four columns (A, B, C, D).
I need something like this :
SELECT COUNT(A) FROM MyTable GROUP BY A, B, DISTINCT(C), DISTINCT(D)
By this query I want to say : I want to group rows with same A, same B, unique C, unique D.
But I cann't use DISTINCT in GROUP BY clause. How can I write it using legal SQL query ???
I will really thanful you if you help me, much thanks.