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