DevProTalk - Pogledajte određenu poruku

bluesman · 09. 05. 2006.

Mozes na primer ovako:

SELECT Count(*) AS Cnt from tabela1 GROUP BY polje1 HAVING Cnt > 1

To ti prikazuje samo broj, ako hoces i koje je to polje onda samo dodaj polje1:

SELECT polje1, Count(*) AS Cnt from tabela1 GROUP BY polje1 HAVING Cnt > 1

Ako hoces da vidis recimo kojih ima tacno 4, onda samo zameni Cnt > 1 u Cnt = 4

ako neko zna bolje - shoot

Jel' sam shvatio?

09. 05. 2006.	#2
bluesman Goran Pilipović Sir Write-a-Lot Datum učlanjenja: 18.05.2005 Lokacija: Beograd Poruke: 5.450 Hvala: 288 1.247 "Hvala" u 446 poruka	Mozes na primer ovako: SELECT Count() AS Cnt from tabela1 GROUP BY polje1 HAVING Cnt > 1 To ti prikazuje samo broj, ako hoces i koje je to polje onda samo dodaj polje1: SELECT polje1, Count() AS Cnt from tabela1 GROUP BY polje1 HAVING Cnt > 1 Ako hoces da vidis recimo kojih ima tacno 4, onda samo zameni Cnt > 1 u Cnt = 4 ako neko zna bolje - shoot Jel' sam shvatio? __________________ Goran Pilipović a.k.a. Ugly Fingers Bradley f.k.a. bluesman I don't always know what I'm talking about but I know I'm right!