有一个表t,结构如下:
id content
1 a
1 a
1 b
1 c
2 a
2 b
2 b
我想得到只出现过一次的记录,结果为:
id content
1 b
1 c
2 a
就是有重复的记录就不要了.
id content
1 a
1 a
1 b
1 c
2 a
2 b
2 b
我想得到只出现过一次的记录,结果为:
id content
1 b
1 c
2 a
就是有重复的记录就不要了.
FROM T
GROUP BY ID,CONTENT
HAVING COUNT(*) = 1
FROM mytab
GROUP BY ID,CONTENT
HAVING COUNT(*) = 1
from(
select id,content,count(*) over(partition by id,content) rn from t_18
) where rn=1