Guest User

Untitled

a guest
Apr 21st, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. SELECT p.nomProd, p.codProd, COUNT(ip.CodProd) FROM Productos p, ImpoProd ip
  2. WHERE
  3. ip.codProd = p.codProd
  4. GROUP BY p.nomProd, p.codProd, ip.codProd
  5. HAVING COUNT(ip.codProd) =
  6. (SELECT MIN(CANTIDAD) FROM
  7. (SELECT ip2.codProd, count(ip2.codProd) AS CANTIDAD
  8. FROM ImpoProd ip2
  9. GROUP BY ip2.codProd
  10. )
  11. );
Add Comment
Please, Sign In to add comment