Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT C_KLIENTA FROM Tabuľka1
  2. WHERE PRODUKT = 'KK' AND NOT PRODUKT = 'BU'
  3. 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