MSAccess: Select Distinct

[ byTer @ 06.02.2004. 00:05 ] @

Imam sledeci query

SELECT DISTINCT Count(solverID) as Num FROM Topics WHERE IsSolved = True AND CID="&CID&" AND solverID <> 0 GROUP BY SolverID

Kad listam rezultate dobijam 3 iako imam samo 0, 1 i 2 u polju SolverID.

Zasto se ovo desava?

[ mladenovicz @ 06.02.2004. 12:07 ] @

Odavno nisam radio nista sa bazama, ali probaj ovo:

SELECT COUNT(SELECT DISTINCT ....)

[ bluesman @ 06.02.2004. 14:36 ] @

zar nebi trebalo SELECT COUNT(DISTINCT nesto).... ?
nije isto SELECT COUNT(DISTINCT nesto) i SELECT DISTINCT COUNT(nesto)

[ byTer @ 06.02.2004. 16:15 ] @

Ne radi...

[ goranvuc @ 08.02.2004. 20:51 ] @

SELECT DISTINCT COUNT(Field) ti vraca broj razlicitih pojava polja Field

[ byTer @ 08.02.2004. 22:41 ] @

Resio sam uz pomoc nested queryja.

Hvala.