Advertisement
Guest User

Untitled

a guest
Jan 11th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select ks.lekime || '-' || ks.sostav as LEKOVI from lek ks where
  2. ks.lekid in
  3. (
  4. select lekid from
  5. (
  6. select count(r.lekid),r.lekid from lek l,recept r
  7. where l.lekid = r.lekid
  8. group by r.lekid
  9. having count(r.lekid) < 3
  10. ) a
  11. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement