sql语句

查询两个表 

select ry_Reference.Reference_Name,ry_Reference.x,ry_Reference.y from ry_Reference_Road_Relation,ry_Reference where ry_Reference_Road_Relation.Reference_ID=ry_Reference.Reference_ID and ry_Reference.Reference_Type="3" and ry_Reference_Road_Relation.Macro_RoadID="510043"
列出road表中所有的road_type类型 

SELECT DISTINCT road_type FROM road
查询重复条目
select T.dldmlddm,count(*) from rm_roadsegitem_ld t group by dldmlddm having count(*)>1
like 

select Road_Name,gx,gy from road where road_name like '%京沪高速%'

发表评论

邮箱地址不会被公开。 必填项已用*标注