You should be able do it with minus and two subqueries. in oracle: select ... where rownum < 150 minus select ... where rownum < 100

sleepingchild (Sleeping Child)
2001-7-25 -04:00
This post has been archived. It cannot be replied.
Page address has been copied. To share, click to copy page address.
Share Online by QR Code

Back To Topic: query结果来自几个表的join, 如何拿到中间一部分记录, 如: 第100 条到第150条.

Back To Forum: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论