je normalni ?

[Jan Serak]

Milan Sorm wrote:
> to view vypada:
> 
> SELECT k_uzivatele.id, cele_jmeno, COUNT(*) from pocet
> FROM fis.k_uzivatele,fis.w_log
> WHERE uzivatel IS NOT NULL AND k_uzivatele.id = w_log.id
> GROUP BY k_uzivatele.id,cele_jmeno
> ORDER BY pocet DESC

Jestli je to na 8i, tak je to divny a melo by to fungovat
(az na ten prvni radek: COUNT(*) from pocet - to from je
doufam preklep). Nicmene Oraklove dlouhou dobu bojuji
se sloupeckovymi aliasy v SELECTech, takze jako prvni radu
mam tuto: zkuste do ORDER BY klauzule dat:

	ORDER BY COUNT(*) DESC

Ale rikam, je to divne, me to na 8i funguje.


					Jan Serak