17,086
社区成员
发帖
与我相关
我的任务
分享发一个SAP的面试问题
很久没做database了，下面是一道SAP的面试题目，望大家指点一下。
“取一个表的第5至第7行记录怎么用SQL表示”
Thanks
“取一个表的第5至第7行记录怎么用SQL表示”
Thanks
...全文
请发表友善的回复…
发表回复
zhp6489 2007-03-15
- 打赏
- 举报
从性能考虑，二楼的回答正解
tianyacao007 2007-03-15
- 打赏
- 举报
都行，顶
chd2001 2007-03-15
- 打赏
- 举报
....
select * from (select rownum num,a.* from tab a) where num>=5 and num<=7
select * from (select rownum num,a.* from tab a) where num>=5 and num<=7
chd2001 2007-03-15
- 打赏
- 举报
SORRY 第一个写错了
select * from (select rownum num,a.* from tab) a where a.num>=5 and a.num<=7
select * from (select rownum num,a.* from tab) a where a.num>=5 and a.num<=7
xiaoxiao1984 2007-03-15
- 打赏
- 举报
select * from
(select tablename.*, rownum rn from tablename where rownum <= 7 )
where rn >= 5
(select tablename.*, rownum rn from tablename where rownum <= 7 )
where rn >= 5
chd2001 2007-03-15
- 打赏
- 举报
select a.* from tab a where rownum>=5 and rownum<=7
