Advertisement
Guest User

Untitled

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