数据结构如下
下面两句的查询结果都是一样的
SELECT
id
FROM
t3
WHERE
(n1, n2) IN (
SELECT
n1,
n2
FROM
t3
WHERE
id <= 2
)
------------------------------------------------------
SELECT
id
FROM
t3
WHERE
(n1, n2) IN ((1, 'a'),(2, 'b'))
结果
id
1
2
统计个数:
SELECT
ybp.box_id,
count( * ) AS num,
yrr.product_id,
ybp.LEVEL,
yb.NAME,
yrr.customer_id,
gc.nick
FROM
yifan_raffle_record yrr
LEFT JOIN yifan_box_product ybp ON yrr.product_id = ybp.id
LEFT JOIN gacha_customer gc ON yrr.customer_id = gc.customer_id
LEFT JOIN yifan_box yb ON ybp.box_id = yb.id
WHERE
ybp.LEVEL !=-