Access-SQL: vypis duplicitnich hodnot – MySQL – Fórum – Programujte.com

Zdravim. Muzete mi prosim nekdo poradit jak se da napsat kod pro vypis duplicitnich hodnot? Potrebuji totiz zobrazit polozku s cenou.Cena u kazde polozky je ruzna.Jedine co se mi podarilo je toto ale umi to jenom vypis dupl. hodnot a jejich pocet.

SELECT tab1.number AS Polozka, Count(tab1.number) AS Pocet
FROM tab1
GROUP BY tab1.number
HAVING (((Count(tab1.number))>1));

s cenou ale bez poctu duplikatu:

SELECT tab1.number AS Polozka, tab1.cena AS cena
FROM tab1
GROUP BY tab1.number AS Polozka, tab1.cena AS cena;

Nieco taketo ?

SELECT tab1.number AS Polozka, tab1.cena AS cena , dupl.Pocet
FROM tab1
Left Join (SELECT tab1.number AS Polozka, Count(tab1.number) AS Pocet FROM tab1) As dupl
On tab1.number = dupl.Polozka

Alebo nieco taketo?

Select tab.Polozka, tab.cena , dupl.Pocet
From (SELECT Distinct tab1.number AS Polozka, tab1.cena AS cena , dupl.Pocet FROM tab1 ) as tab
Left Join (SELECT tab1.number AS Polozka, Count(tab1.number) AS Pocet FROM tab1) As dupl
On tab.number = dupl.Polozka