去除重复记录Sql

[duan17]

id flag name
1 send a
1 send b
1 send c
1 rece a
1 rece b
2 rece d

要显示的结果
1 send a
1 rece a
2 rece d

就是先按flag分组,然后去除id 列重复的

[Ineed123]

select a.* from table1 a where rowid>(select min(rowid) from table1 b where a.id=b.id and a.flag=b.flag)

[liuchunjp]

http://dev.csdn.net/develop/article/56/article/50/50484.shtm

[ORARichard]

select a.* from 表 a,
(
select min(rowid) no from 表 group by id,flag
) b
where a.rowid=b.no;

[delphi_dcs]

不会吧，怎么比sqlserver差那么多，distinct就可以了，看来oracle听罗嗦的

[ORARichard]

to delphi_dcs(delphi人生)

ORACLE当然支持DISTINCT
不过你试试你的想法，看看能不能实现楼主的要求

[子陌红尘]

select
id ,
flag ,
max(name) as name
from
表
group by
id, flag
order by
id, flag

[etheltim]

利用rowid

[chentony]

select a,b,c
from aa a
where c = (select c from aa where a = a.a and b = a.b and rownum = 1 )

[chentony]

SELECT id,flag,name
FROM table_name a
WHERE name = (SELECT c
FROM table_name
WHERE id = a.id AND flag = a.flag and rownum = 1 )

[lynx]

try this one:
select id,flag,name from (
select row_number() over (partition by id,flag order by name) rn ,my_test.*
from my_test )
where rn=1;

[liuyi8903]

这种情况.我想sqlserver也不能用distinct来实现.distinct出来的结果是不正确的.
它的用途只是以flag为主的列的各种组合.
我想sqlserver也不例外