home *** CD-ROM | disk | FTP | other *** search
/ PC World 2003 December / PCWorld_2003-12_cd.bin / Software / komercni / alc / ep2sr51csy.msi / Ep.CAB / q10 < prev    next >
Text File  |  2003-08-18  |  307b  |  9 lines
  1. SELECT AS "OperaΦnφ systΘmy"=S "OS"=S1.@product, "PoΦφtaΦ"=@object, "Inventßrnφ Φφslo"=[inventßrnφ Φφslo], "U₧ivatel"=[u₧ivatel], "OS - sΘriovΘ Φφslo"=S1.@description
  2. WHERE druh="sestava"
  3. WITH
  4.     SELECT SWINST AS S1 
  5. WHERE @category=SW_OS
  6. HAVING S1
  7. ENDWITH
  8. GROUP BY S1.@product
  9. COUNT BY S1.@product