select rownum, 'ckqy5' as layer, 'Default' as tag, 'POLYGON' as type, c.smid, c.name as title, c.examincode, x.roadnames as road from 交叉点 x left join ckqy5 c on x.ckqy5id = c.examincode where c.examincode like'%%' and x.roadnames like '%%,%%' and rownum <= 10 group by();想要得到的结果是如果title,examincode, road这三个字段全部相同的话只显示其中一条
解决方案 »
- 高手请进!!!
- 谁能帮我100分 Struts
- spring+hibernate+struts的配置问题,google了3个小时没解决,崩溃!
- 在websphere中,怎样用JTA管理两个数据库,不用EJB,用JDBC
- 关于 classpath 和 java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver 问题求解
- 100分!求助!JAVA如何用远程接口调用在群集中部署的EJB???
- 请问什么叫轻量级什么叫重量级?
- 一个疑问:ejb中是怎样实现复杂查询的?
- jsp转换为xml
- struts 上传文件 第一次可以上传 进行第二次上传出错
- 求大神解答,在struts2的拦截器中 ,怎么获取当前action中的ActionError呢
- java注解
'ckqy5' as layer,
'Default' as tag,
'POLYGON' as type,
c.smid,
c.name as title,
c.examincode,
c.roadnames as road
from (
select distinct c.name as title,
c.examincode,
x.roadnames as road
from 交叉点 x
left join ckqy5 c on x.ckqy5id = c.examincode
where c.examincode like '%%'
and x.roadnames like '%%,%%'
and rownum <= 10
group by name,examincode,roadnames
)c