17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> desc t_reply;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(18)
ARTICLE_ID NOT NULL NUMBER(18)
CONTENT NOT NULL NCLOB
USERID NOT NULL NUMBER(18)
CREATETIME DATE
SQL>
select article_id from(
select rownum row_number,T.* from(
SELECT * FROM(
select row_number()over(partition by article_id order by article_id) rn,
t_reply.* from t_reply)where rn =1 order by CREATETIME desc)T)where row_number<=10
select article_id
from (select distinct rownum rn,article_id,max(CREATETIME) rq from t_reply group by article_id order by rq desc)
where rn<=10;
SELECT ARTICLE, CREATETIME
FROM (SELECT ARTICLE_ID,
CREATETIME,
ROW_NUMBER() OVER(PARTITION BY ARTICLE ORDER BY CREATETIME DESC) RN
FROM T_REPLY)
WHERE RN < 11
select distinct rownum rn,article_id from t_reply order by CREATETIME desc
select article_id
from (select rownum,article_id,row_number()over(partition by article_id order by article_id) rn
from t_reply
where rn =1--去掉重复的article_id
order by CREATETIME desc)
where rownum <= 10;
select ID, ARTICLE_ID, CONTENT, USERID, CREATETIME
from (select ID,
ARTICLE_ID,
CONTENT,
USERID,
CREATETIME,
row_number() over(partition by ARTICLE_ID order by CREATETIME) rn
from t_reply)
where rn = 1
and rownum <= 10
order by CREATETIME
select article_id
from (select rownum,article_id,rownum()over (partition by article_id) rn
from t_reply
where rn =1--去掉重复的article_id
order by CREATETIME desc)
where rownum <= 10;
select article_id
from (select distinct rownum rn,article_id from t_reply order by CREATETIME desc)
where rn<=10;