tag:blogger.com,1999:blog-4033776284689132542.post6029289038170794674..comments2022-03-30T01:14:29.775+05:30Comments on Abeish Babu: DQL query similar to TOP and ROWCOUNT in SQLAbeish Babuhttp://www.blogger.com/profile/12213376389898185749noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4033776284689132542.post-74797388185967357272018-07-09T20:06:00.898+05:302018-07-09T20:06:00.898+05:30select r_object_id from dm_document ENABLE(FETCH_A...select r_object_id from dm_document ENABLE(FETCH_ALL_RESULTS 5) will return the first five records<br /><br />it works to me! nice :)@iDarvinhttps://www.blogger.com/profile/04782020178655119487noreply@blogger.comtag:blogger.com,1999:blog-4033776284689132542.post-91651400147438644422018-07-09T20:04:38.129+05:302018-07-09T20:04:38.129+05:30bullshitbullshit@iDarvinhttps://www.blogger.com/profile/04782020178655119487noreply@blogger.comtag:blogger.com,1999:blog-4033776284689132542.post-74347763149448014412015-01-28T17:21:14.683+05:302015-01-28T17:21:14.683+05:30Thanks. can also use
SELECT object_name FROM dm_do...Thanks. can also use<br />SELECT object_name FROM dm_document ENABLE (RETURN_TOP 10);Swapnilhttps://www.blogger.com/profile/03826397563848932572noreply@blogger.comtag:blogger.com,1999:blog-4033776284689132542.post-36238172466118220312013-03-13T16:51:57.530+05:302013-03-13T16:51:57.530+05:30It works, thanks =)It works, thanks =)Anonymousnoreply@blogger.com