MySQL select, ali malo tezi (za mene :))

MySQL select, ali malo tezi (za mene :)) 12.02.2006. u 18:28 · pre 252 meseca #1

Ola,

Treba mi sledece:

Code:

SELECT filename, count(filename) as nr from TABELA where nr <= 10 and type = 2 GROUP BY filename ORDER BY nr DESC

Ali da radi :)
Dakle, svi fajlovi, koji se manje od 10 x ponavljaju :)

Sada mi javlja gresku:

Code:

#1054 - Unknown column 'nr' in 'where clause'

Poz,
Sale

Potpis

=========
Uporedi cene i karakteristike za vise od 10.000 proizvoda, izmedju ostalog:
Digitalni foto-aparati
Mobilni telefoni
Skolski pribor
=========

Re: MySQL select, ali malo tezi (za mene :)) 12.02.2006. u 19:10 · pre 252 meseca #2

jesi li probao sa:

Code:
SELECT filename, count(*) AS nr FROM tabela WHERE nr <= 10 AND type = 2 GROUP BY filename ORDER BY nr DESC

mislim da ti je problem u * (DzOKERU)
nisam siguran ali ako nisi, probaj!

Re: MySQL select, ali malo tezi (za mene :)) 12.02.2006. u 22:49 · pre 252 meseca #3

Cao,

nece, vraca istu gresku kao i da je umesto * filename... :(

Iz nekog razloga, ne prepoznaje 'nr' koji je pre toga odradio :S

Poz,
Sale

Potpis

=========
Uporedi cene i karakteristike za vise od 10.000 proizvoda, izmedju ostalog:
Digitalni foto-aparati
Mobilni telefoni
Skolski pribor
=========

Re: MySQL select, ali malo tezi (za mene :)) 13.02.2006. u 00:04 · pre 252 meseca #4

"AS nr" je "odradio" posle, tek kad ti uradi query i prebroji filenameove

Uradi nešto tipa:

Code:
SELECT * FROM
(
  SELECT filename, count(filename) AS nr
  FROM TABELA
  WHERE type = 2
  GROUP BY filename
) a
WHERE a.nr <= 10
ORDER BY a.nr DESC

Re: MySQL select, ali malo tezi (za mene :)) 13.02.2006. u 00:25 · pre 252 meseca #5

Probaj nesto ovako:

Code:
SELECT filename, count(filename) as nr from TABELA where type = 2 GROUP BY filename having nr <= 10 ORDER BY nr DESC

Potpis

Caught in a Web|Blogodak

Re: MySQL select, ali malo tezi (za mene :)) 13.02.2006. u 09:38 · pre 252 meseca #6

Nisi obratio paznju na: https://www.elitesecurity.org/t160319-where-group-by-problem

Re: MySQL select, ali malo tezi (za mene :)) 13.02.2006. u 11:14 · pre 252 meseca #7

Npr:

Select filename, Count(filename) As nr
From Tabela
Where type=2
Group by filename
Having Count(filename)<= 10
Order by Count(filename) Desc

Poz

Re: MySQL select, ali malo tezi (za mene :)) 13.02.2006. u 17:29 · pre 252 meseca #8

@srdjan - mysql 4 :( nemam tu mogucnost :(
@ana - ne radi, invalid use of group :(

@dinke - RADI! :) Hvala!

U pravu ste, nisam svuda i sve pregledao, kasno je bilo, ja nervozan i odustao :)

Anyway, hvala, resenje radi! :)

Poz,
Sale

Potpis

=========
Uporedi cene i karakteristike za vise od 10.000 proizvoda, izmedju ostalog:
Digitalni foto-aparati
Mobilni telefoni
Skolski pribor
=========

Forum kao aplikacija na telefonu

Srodne teme