Comments (...)

SQL - Test duplicity zboží

 

SELECT

   "AutoInc",Cislo,Nazev,ZasobaMJ,ZasobaKc,ZdrojovaCena,Cena01,Cena02,

   ZmenaKod,ZmenaDatum,ZmenaDatumServer

FROM

   HK__Z201

WHERE

   Cislo IN

(

SELECT

   Cislo

FROM

(

SELECT

   *

FROM

(

SELECT

   Count(Cislo) AS Pocet,

   Cislo

FROM

   HK__Z201

GROUP BY

   Cislo

) AS x

WHERE

   Pocet>1

) AS xx

)

ORDER BY

   Cislo

 

Comments (...)