select * from (
SELECT UNIQUE
cddealer as cdDealer100_0_,
nmdealer as nmDealer100_0_,
'' as dtPsi100_0_,
'' as branchID100_0_,
'' as subBranc6_100_0_,
'' as channelID100_0_,
'' as subChann8_100_0_, // 这里多了个逗号。
FROM
( SELECT * FROM ( SELECT /*+ USE_HASH(vi psi) */ vi.cd_dealer cddealer, vi.nm_dealer nmdealer, psi.dt_psi dtPsi, vi.nm_branch branch, vi.nm_sub_branch subBranchn,vi.nm_sales_grp salesGrp,
vi.nm_channel channel,vi.nm_sub_section subChannel
FROM
t_subdealer_psi psi, v_report_dealer vi
WHERE 1 = 1
AND vi.cd_dealer = psi.cd_whole_seller
and psi.DT_PSI >= TO_DATE(?,'YY-MM-DD')
and psi.DT_PSI <= TO_DATE(?,'YY-MM-DD') ) WHERE 1 = 1 ) ) where rownum <= ?
解决方案 »
- Hibernate奇怪问题
- 急急急,java 学员,做jsp时有了数据库访问类为什么还要个业务类啊?
- jfreechart饼图如何能在中间部份显示所有数据的统计结果
- 一个严重的错误,寻求答案????
- 如果链接到GOOGLE进行查询
- 上海的进来看看,帮朋友公司招JSP程序员一名,急
- 请问Struts中同名文本框提交该怎么获得?
- 能否将Tomcat编译生成的Servlet放在自己设定的目录下,而不是Tomcat默认的目录下?
- 散分,一定要把5000分都散掉!!不留,坚决的不留!
- 请问封装好的jsp上传组件有哪些?在哪里下载?jspsmartupload除外
- HTTP Status 500 让我头痛的东西。
- 请教WEB问题
select * from
(
SELECT UNIQUE
cddealer as cdDealer100_0_,
nmdealer as nmDealer100_0_,
'' as dtPsi100_0_,
'' as branchID100_0_,
'' as subBranc6_100_0_,
'' as channelID100_0_,
'' as subChann8_100_0_
FROM
( SELECT * FROM
(
SELECT vi.cd_dealer as cddealer,
vi.nm_dealer as nmdealer,
psi.dt_psi as dtPsi,
vi.nm_branch as branch,
vi.nm_sub_branch as subBranchn,
vi.nm_sales_grp as salesGrp,
vi.nm_channel as channel,
vi.nm_sub_section as subChannel
FROM
t_subdealer_psi psi, v_report_dealer vi
WHERE 1 = 1
AND vi.cd_dealer = psi.cd_whole_seller
and psi.DT_PSI >= TO_DATE(?,'YY-MM-DD')
and psi.DT_PSI <= TO_DATE(?,'YY-MM-DD')
)
WHERE 1 = 1
)
)
where rownum <= ?看看这个可以不。
SELECT UNIQUE
cddealer as cdDealer100_0_,
nmdealer as nmDealer100_0_,
'' as dtPsi100_0_,
'' as branchID100_0_,
'' as subBranc6_100_0_,
'' as channelID100_0_,
'' as subChann8_100_0_, // 这里多了个逗号。
FROM
( SELECT * FROM ( SELECT /*+ USE_HASH(vi psi) */ vi.cd_dealer cddealer, vi.nm_dealer nmdealer, psi.dt_psi dtPsi, vi.nm_branch branch, vi.nm_sub_branch subBranchn,vi.nm_sales_grp salesGrp,
vi.nm_channel channel,vi.nm_sub_section subChannel
FROM
t_subdealer_psi psi, v_report_dealer vi
WHERE 1 = 1
AND vi.cd_dealer = psi.cd_whole_seller
and psi.DT_PSI >= TO_DATE(?,'YY-MM-DD')
and psi.DT_PSI <= TO_DATE(?,'YY-MM-DD') ) WHERE 1 = 1 ) ) where rownum <= ?