SELECT ROWNUM,ID FROM (SELECT ID,ROWNUM AS RID FROM ROAD) WHERE RID BETWEEN ".$p_start." AND ".$p_end." ORDER BY ID ASC