--Select client with at least two invoices
__________________________________________count___________________________________________________
看一下COUNT的用法:
SELECT client_id, COUNT(*)
FROM invoices
GROUP BY client_id
Output:
__________________________________________count______________________________________________________
SELECT client_id, COUNT(*)
FROM invoices
GROUP BY client_id
HAVING COUNT(*) >= 2
Output:
___________________________________________________________________完整code——————————————————————————————————————————————
SELECT *
FROM clients
WHERE client_id IN(
SELECT client_id
FROM invoices
GROUP BY client_id
HAVING COUNT(*) >= 2
)
Or:ANY 关键字方法 : 返回ANY里面任意一个
SELECT *
FROM clients
WHERE client_id = ANY(
SELECT client_id
FROM invoices
GROUP BY client_id
HAVING COUNT(*) >= 2
)
Output: