Posted By: znouza (- Armored Pilsener -) on 'CZdatabases' Title: Re: SQL problem. Date: Fri Mar 5 00:48:24 1999 Mozne reseni: tabulka vypada napr. nasledovne: kli_ID text 1 ABC 1 ABCD 1 ABC 2 PSVZ 2 PSVZ 3 LFGH dotaz: SELECT kli_ID, text, COUNT(kli_ID) as countNo FROM tabulka GROUP BY kli_ID, text vysledek bude: kli_ID text countNo 1 ABC 2 1 ABCD 1 2 PSVZ 2 3 LFGH 1 Staci to takhle ?:)) _ _ /-------- znouza ( o)(o ) /__________ || | | || |_| "The game of life is hard to play..." ** __| 3T