晕,好像是我想错了,如果要返回有WHERE字句的查询的前十条可以这样写: SELECT * FROM student a WHERE (SELECT count(*) FROM student b WHERE b.rownum < a.rownum ) <=10; WHERE子句还可以加上别的内容,比方说要选择名字等于Mike的学生的信息: SELECT * FROM student a WHERE name = 'Mike' and (SELECT count(*) FROM student b WHERE name = 'Mike' and b.rowid < a.rowid ) <10;
SELECT * FROM student a WHERE (SELECT count(*) FROM student b WHERE b.rownum < a.rownum ) <=10;
WHERE子句还可以加上别的内容,比方说要选择名字等于Mike的学生的信息:
SELECT * FROM student a WHERE name = 'Mike' and (SELECT count(*) FROM student b WHERE name = 'Mike' and b.rowid < a.rowid ) <10;
取出前几条的操作最好到代码里去控制。