摘要:SQL SERVER的rownum
select * from (
select ROW_NUMBER() OVER(ORDER BY resource_id) AS ROWID,*
from YDD_RESOURCE_DESCRIPTION where RESOURCE_TYPE_ID='6'
) a where ROWid=3;
oracle的rownum>>>>>>>>>>>>>>>>>>>>
SELECT ROWNUM ROWNO from dual;