The same criteria can be achieved in DQL using the following parameter ENABLE(FETCH_ALL_RESULTS
select r_object_id from dm_document ENABLE(FETCH_ALL_RESULTS 5) will return the first five records
select r_object_id from dm_document ENABLE(FETCH_ALL_RESULTS 0) will return the entire results collection.
For more information can be found at : http://robineast.wordpress.com/2007/08/14/dql-hints-optimize-top/
It works, thanks =)
ReplyDeleteThanks. can also use
ReplyDeleteSELECT object_name FROM dm_document ENABLE (RETURN_TOP 10);
bullshit
ReplyDeleteselect r_object_id from dm_document ENABLE(FETCH_ALL_RESULTS 5) will return the first five records
ReplyDeleteit works to me! nice :)