展开全部
SELECT
t.file_id
FROM
app_polly_file_labels t
WHERE
t.style = ‘清新’
or t.style = ‘甜美32313133353236313431303231363533e78988e69d8331333431353266’
or t.style = ‘韩潮来袭’
GROUP BY t.file_id
HAVING count(t.file_id)=3
或者
SELECT
a.file_id
FROM
app_polly_file_labels a
INNER JOIN app_polly_file_labels b ON a.file_id = b.file_id
INNER JOIN app_polly_file_labels c ON a.file_id = c.file_id
WHERE
a.style =’清新’
AND b.style =’甜美’
AND c.style =’韩潮来袭’
扩展资料：
sql常用的复杂查询语句
一、选择指定的列
select Sno as 学号,Sname as 姓名 from student
select Sno,Sname from student
二、查询全部列
select * from student
三、对查询后的指定列进行命名
select Sname as 姓名