34,587
社区成员
发帖
与我相关
我的任务
分享
select * from tab4 as a where (a.name LIKE '*三*' or a.accouterments LIKE '*三*'or a.interest LIKE '*三*') and not exists(select 1 from tab4 as b where (b.name LIKE '*三*' or b.accouterments LIKE '*三*'or b.interest LIKE '*三*') and b.name=a.name and b.id<a.id) order by a.id
select * from tab4 as a where a.name+a.accouterments+a.interest LIKE '*三*' and not exists(select 1 from tab4 as b where b.name+ b.accouterments+b.interest LIKE '*三*' and b.name=a.name and b.id<a.id) order by a.id
select * from tab4 as a where a.accouterments LIKE '*衣*' and not exists(select 1 from tab4 as b where b.accouterments LIKE '*衣*' and b.name=a.name and b.id<a.id) order by a.id
/*
ID name accouterments
1 张三 衣服
4 李四 衣服
7 王五 衣服
*/
SELECT *
FROM tab1 AS a
WHERE accouterments LIKE '*衣*'
AND NOT EXISTS ( SELECT 1
FROM tab1 AS b
WHERE b.accouterments LIKE '*衣*'
AND b.name = a.name
AND id < a.id )