Advertisement
Guest User

Untitled

a guest
Apr 4th, 2020
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.25 KB | None | 0 0
  1. SELECT *,
  2.     COUNT(*) as counter
  3. FROM
  4.     customers c
  5.     LEFT JOIN invoices i ON c.CustomerId = i.CustomerId
  6. GROUP BY
  7.     i.CustomerId
  8. HAVING
  9.     counter = (
  10.         SELECT
  11.             COUNT(i.CustomerId)
  12.         FROM
  13.             invoices i
  14.         GROUP BY
  15.             i.CustomerId
  16.         LIMIT 1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement