select rownum no, a.* 
FROM (select BIB_NO,LANG_CODE,PUB_YEAR,COLLECTION_CODE,MTYPE_CODE,LOCATION_CODE,STATUS,CREATED_DATETIME,MODIFIED_DATETIME,TITLE,AUTHOR,CALLNO from BIB_LIMIT 
order by BIB_NO desc) a 
where 1=1