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这三个字段全部相同的话只显示其中一条
解决方案 »
- 帮我分析下为什么这个javamail程序错误密码也能connect上去
- java.io.IOException: 句柄无效 异常是什么引起的
- 接手的旧项目,帮忙解决struts2 type="json"的问题~
- 关于一个是否使用application疑问!
- 帮忙写个正则..
- mysql + hibernate 出现的中文乱码问题
- 如何以网页形式向远程服务器串口发送命令
- 学习struts(问题很简单,这分很好得)
- 我的TOMCAT与APACHE已经整合成功,但JSP运行出错,在线等!急
- 通过Weblogic快速搭建Je22架构,通过就给分??
- 求大神解答,在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