大虾们看看我的SQL,
select m.id, m.title, m.createdate, m.publisher, m.publishername,count(t.id) as replyCounts
from epare_safe_callboard m left join epare_safeboard_supplyment t on m.id=t.safeboradid, epare_safe_callboard_view v
where (validdate-sysdate)>=-1 and m.id=v.SAFEBOARDID and v.userid= 4107 and v.VIEWFLAG=0
group by m.id, m.title, m.createdate, m.publisher, m.publishername order by 1 desc union select m.id, m.title, m.createdate, m.publisher, m.publishername,count(t.id) as replyCounts
from epare_safe_callboard m left join epare_safeboard_supplyment t on m.id=t.safeboradid
where (validdate-sysdate)>=-1 and m.DEPTCID= '九部'
group by m.id, m.title, m.createdate, m.publisher, m.publishername order by 1 desc
我做了测试.2个SQL是可以运行的,为什么加了union就不行了,总是报命令未正确结束,这是怎么回事啊?
select m.id, m.title, m.createdate, m.publisher, m.publishername,count(t.id) as replyCounts
from epare_safe_callboard m left join epare_safeboard_supplyment t on m.id=t.safeboradid, epare_safe_callboard_view v
where (validdate-sysdate)>=-1 and m.id=v.SAFEBOARDID and v.userid= 4107 and v.VIEWFLAG=0
group by m.id, m.title, m.createdate, m.publisher, m.publishername order by 1 desc union select m.id, m.title, m.createdate, m.publisher, m.publishername,count(t.id) as replyCounts
from epare_safe_callboard m left join epare_safeboard_supplyment t on m.id=t.safeboradid
where (validdate-sysdate)>=-1 and m.DEPTCID= '九部'
group by m.id, m.title, m.createdate, m.publisher, m.publishername order by 1 desc
我做了测试.2个SQL是可以运行的,为什么加了union就不行了,总是报命令未正确结束,这是怎么回事啊?
解决方案 »
- SQL*Net是否是加密进行传输的
- SQL语句看不懂
- 把excel或txt或access 导入oracle的问题。无目的表,如何在导入oracle时按原来表名自动创建表 并导入数据。
- 在一台机器上可以同时装SQL Server和Oracle吗?
- 谁能帮我分析下下面的sql语句
- 从oracle网站上下载来的oracle,有什么限制吗?跟正版的有什么区别?我从他网站上下载一个.安装时出现一大堆提示,说文件找不到!
- oracle表字段里类似于tab的长空格怎么去掉?
- 怎么用Oracle Spatial建立数据库呢?刚把Oracle8i装上,不知道从那个程序进去,怎么动手?
- 几个初级问题
- 偶对Oracle七窍通了六窍,请各位推荐一些书记或文章
- oracle中修改数据库的日期显示格式问题?
- oralce/mysql的分页,分组,分组筛选函数
union前的 order by 1 desc 要去掉
from epare_safe_callboard m left join epare_safeboard_supplyment t on m.id=t.safeboradid, epare_safe_callboard_view v
where (validdate-sysdate)>=-1 and m.id=v.SAFEBOARDID and v.userid= 4107 and v.VIEWFLAG=0
group by m.id, m.title, m.createdate, m.publisher, m.publishername
union
select m.id, m.title, m.createdate, m.publisher, m.publishername,count(t.id) as replyCounts
from epare_safe_callboard m left join epare_safeboard_supplyment t on m.id=t.safeboradid
where (validdate-sysdate)>=-1 and m.DEPTCID= '九部'
group by m.id, m.title, m.createdate, m.publisher, m.publishername
order by 1 desc