SQL語句IN的用法

rooderPrime發表於2020-12-11
SQL

1.查詢後分組

SELECT r_id, COUNT(r_id) ‘favNumber’
FROM mx_like
WHERE
l_type=‘fav’ AND l_is_like = TRUE AND deleted=0
AND r_id IN (1,1288397893945970690,1308658209325793282) GROUP BY r_id

在這裡插入圖片描述

2.查詢後不分組

SELECT r_id, COUNT(r_id) ‘favNumber’
FROM mx_like
WHERE
l_type=‘fav’ AND l_is_like = TRUE AND deleted=0
AND r_id IN (1,1288397893945970690,1308658209325793282)

在這裡插入圖片描述

相關文章