帮忙看条SQL语句

[sky_2008]

select * from GARDEN_IN_GARDEN a inner join divison_road b on substr(a.GARDEN_ID,7,4)='6003' and b.divison_id='6003'

结果：
GARDEN_ID OWNER_ID ROAD_NAME
------------- ----------
1004506003001 100450 淠河路
1004506003002 100450 淠河路

现在想实现这样：
GARDEN_ID OWNER_ID ROAD_NAME
------------- ----------
1004506003001 100450 淠河路
1004506003002 100450 null

请问上面的SQL语句该怎么改，谢了

[xiaoxiao1984]

先给出表结构，给出例子的数据，要不很难看得懂楼主的意思

[sky_2008]

id name
1 a
2 a
3 b
4 b
怎么让name字段的重复值不显示，id字段不变呢例如：
id name
1 a
2 b
3
4

这样写应该明白了吧

[yanhawk]

这个应该就是update重复记录吧

update test a set a.name = null
where a.id< (select max(id) id from test b where a.name=b.name)

[xiaoxiao1984]

SQL> select *from tab_1;

ID NAM
---------- ---
1 a
2 a
3 b
4 b

SQL> select a.id, b.name
2 from (select rownum as rid,id from tab_1 )a
3 left join
4 ( select rownum as rrid,name from (select distinct name from tab_1 ) )b
5 on a.rid = b.rrid
6 order by a.id ;

ID NAM
---------- ---
1 a
2 b
3
4

[sky_2008]

xiaoxiao1984(笨猫一只^_^)
我试了下，没有太明白，能不能在我原来的SQL语句中帮我改一下

select * from GARDEN_IN_GARDEN a inner join divison_road b on substr(a.GARDEN_ID,7,4)='6003' and b.divison_id='6003'

[sky_2008]

还是不明白，

[qiekong]

id需要，有不要重复记录，怎么可能，

请问当name重复时，该取那一name的id值

[gudelihe]

select name from 表 group by name

[rogerfhl]

恩,笨猫方法不错