SELECT * FROM (SELECT a.*, ROWNUM RN FROM (SELECT * FROM sasa) a WHERE u_id in (select u_id from friend where uf_id=241) and ROWNUM <7 )WHERE RN >0 SELECT * FROM (SELECT a.*, ROWNUM RN FROM (SELECT * FROM sasa) a WHERE u_id in (select uf_id from friend where u_id=241) and ROWNUM <4 )WHERE RN >0怎么才能把这两个合成一个呢?
用union all?
第一个的查询不是包含第二个查询的结果吗?如果要两个查询的结果连接在一起显示的话用union all
FROM sasa a
WHERE a.u_id in (select u_id from friend where uf_id=241)
and ROWNUM .....这样试试。
SELECT *
FROM (SELECT a.*, ROWNUM RN
FROM (SELECT * FROM sasa) a
WHERE u_id in (select u_id
from friend
where uf_id = 241)
and ROWNUM < 7
);
--WHERE RN > 0--2.
SELECT *
FROM (SELECT a.*, ROWNUM RN
FROM (SELECT * FROM sasa) a
WHERE u_id in (select u_id
from friend
where uf_id = 241)
and ROWNUM < 4
)
--WHERE RN > 01和2明显存在3条重复记录。你是要去重呢?还是并上重呢?