Advertisement
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);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement