a guest Jul 18th, 2019 85 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT C_KLIENTA FROM Tabuľka1
- WHERE PRODUKT = 'KK' AND NOT PRODUKT = 'BU'
- INNER JOIN (SELECT C_KLIENTA, COUNT(C_KLIENTA) FROM Tabuľka1 GROUP BY C_KLIENTA HAVING COUNT(C_KLIENTA)>1) AS tabulka2 ON (Tabuľka1.C_KLIENTA=tabulka2.C_KLIENTA);
RAW Paste Data