已知value select * from (select * from tablename where col = 'value') where rownum < 6; ---------------------------- 未知value select * from (select * from tablename where exists(select * from tablename t where t.col = tablename.col) order by col) where rownum < 6;
SELECT * FROM TAB A WHERE ROWID > ( SELECT MAX(ROWID) FROM TAB B WHERE A.FIELD = B.FIELD ) AND RONUM < 6
函数错了~:)应该是 SELECT * FROM TAB A WHERE ROWID > ( SELECT MIN(ROWID) FROM TAB B WHERE A.FIELD = B.FIELD ) AND ROWNUM < 6
抱歉,写错了,我这里8i是select column1 from table1 group by aaa having rownum<=5
select * from yourtable a where exist ( select col1 from yourtable b where a.col1=b.col1 group by b.col1 having count(*) > 1 ) and rownum < 6
select * from (select * from tablename where col = 'value') where rownum < 6;
----------------------------
未知value
select *
from (select *
from tablename
where exists(select * from tablename t where t.col = tablename.col)
order by col)
where rownum < 6;
WHERE ROWID > ( SELECT MAX(ROWID) FROM TAB B WHERE A.FIELD = B.FIELD )
AND RONUM < 6
SELECT * FROM TAB A
WHERE ROWID > ( SELECT MIN(ROWID) FROM TAB B WHERE A.FIELD = B.FIELD )
AND ROWNUM < 6
( select col1 from yourtable b where a.col1=b.col1
group by b.col1
having count(*) > 1
) and rownum < 6