In Oracle if you want to limit the records based on ROWNUM(mostly while doing pagination) the between is not going to work.<\/p>\n
Below Doesn’t work<\/strong><\/p>\n The alternate for this is as Follows<\/p>\n In Oracle if you want to limit the records based on ROWNUM(mostly while doing pagination) the between is not going to work. Below Doesn’t work SELECT Column1, Column2, ……., Column N FROM TableName WHERE ROWNUM Between 5 AND 10; The alternate for this is as Follows SELECT * FROM (SELECT rows_to_page.*, ROWNUM rnum FROM (SELECT… Continue reading \r\n SELECT Column1, Column2, ......., Column N \r\n FROM TableName\r\n WHERE ROWNUM Between 5 AND 10; \r\n<\/pre>\n
\r\nSELECT * FROM\r\n (SELECT rows_to_page.*, ROWNUM rnum FROM\r\n (SELECT Column1, Column2, ......., Column N \r\n FROM TableName\r\n WHERE ROWNUM Between 5 AND 10) rows_to_page\r\n WHERE ROWNUM < end_offset) \r\n WHERE rnum > start_offset;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"