为啥有个嵌套查询 根据分类号查询。
试试这个呢select *
from (select A.*, ROWNUM RN
from (select s.itemid,
t.typename,
s.title,
s.userid,
m.companyname,
s.publishdate,
s.categoryid,
s.clicknum,
count(s.id) over(partition by s.categoryid) as matchcount
from sd_supplydemand s,
sd_type t,
tbl_221_member m,
tbl_221_regions r/*,
(select s.categoryid, count(*) as matchcount
from sd_supplydemand s
group by s.categoryid) tb*/
where s.typeid = t.typeid
and s.userid = m.userid
and s.country = r.regionid
/*and s.categoryid = tb.categoryid*/
order by s.publishdate desc) A)
order by publishdate desc
试试这个呢select *
from (select A.*, ROWNUM RN
from (select s.itemid,
t.typename,
s.title,
s.userid,
m.companyname,
s.publishdate,
s.categoryid,
s.clicknum,
count(s.id) over(partition by s.categoryid) as matchcount
from sd_supplydemand s,
sd_type t,
tbl_221_member m,
tbl_221_regions r/*,
(select s.categoryid, count(*) as matchcount
from sd_supplydemand s
group by s.categoryid) tb*/
where s.typeid = t.typeid
and s.userid = m.userid
and s.country = r.regionid
/*and s.categoryid = tb.categoryid*/
order by s.publishdate desc) A)
order by publishdate desc
解决方案 »
- oracle 存储过程 高手帮忙改一下
- 菜鸟求教大虾小虾们,协议适配器错误的问题,恳请各位解惑
- oracle 数字+字母排序问题
- UNIX下的线程与ORACLE数据库的连接问题,在线等待!!
- ORA-08002: 尚未在這個階段作業中定義序列 CS_ADDRESS_SEQ.CURRVAL,一个比较奇怪的现象,请高手指教
- 请教:用哪个字符集比较好?
- 什么是归档模式?
- 请问如何把字符串的日期'20050123101113'转换成日期格式2005-1-23 10:11:13?
- 请教一个sql语句如何写----在线等待!!
- 问一个问题:我是在oracle网站上下在的PROVIDER FOR 9i,我现在是写asp程序,连接字串还是用这样的吗?请进
- PL/SQL登录问题在线急等。。。。。
- oracle导入dmp文件求助!
有没有添加上分页select s.itemid,
t.typename,
s.title,
s.userid,
m.companyname,
s.publishdate,
s.categoryid,
s.clicknum,
count(s.id) over(partition by s.categoryid) as matchcount
from sd_supplydemand s,
sd_type t,
tbl_221_member m,
tbl_221_regions r
where s.typeid = t.typeid
and s.userid = m.userid
and s.country = r.regionid
order by s.publishdate desc
(
select A.*, seq.nextval RN from (
select s.itemid,t.typename,s.title,s.userid,m.companyname,s.publishdate,s.categoryid,s.clicknum,tb.matchcount
from sd_supplydemand s,sd_type t,tbl_221_member m
(select s.categoryid,count(*) as matchcount from sd_supplydemand s group by s.categoryid) tb
where s.typeid = t.typeid and s.userid = m.userid and s.country = r.regionid and s.categoryid = tb.categoryid
and exists (select 1 from tbl_221_regions r where s.country = r.regionid )
order by s.publishdate desc
) A)
/* order by publishdate desc*/