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语句该怎么改,谢了
GARDEN_ID OWNER_ID ROAD_NAME
------------- ----------
1004506003001 100450 淠河路
1004506003002 100450 淠河路现在想实现这样:
GARDEN_ID OWNER_ID ROAD_NAME
------------- ----------
1004506003001 100450 淠河路
1004506003002 100450 null请问上面的SQL语句该怎么改,谢了
1 a
2 a
3 b
4 b
怎么让name字段的重复值不显示,id字段不变呢例如:
id name
1 a
2 b
3
4 这样写应该明白了吧
---------- ---
1 a
2 a
3 b
4 bSQL> 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
我试了下,没有太明白,能不能在我原来的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'
where a.id< (select max(id) id from test b where a.name=b.name)