정렬쿼리

int start = pagesize*gotopage;

if(start > recordcount) pagesize -= (start-recordcount);

 

select * from(select top "+pagesize+" * from(selcet top "+start+" *from seoul order by re_step desc) as DERIVEDTBL irder by re_step) as DERIVEDTBL order by re_step desc

 

순서  :  re_step 내림차순 -> 가져온 값 pagesize 오름차순 -> 가져온값 내림차순