Thursday, February 10, 2011

ROW_NUM for paging table

select * from (
select id,name,ROW_NUMBER() OVER(ORDER BY id) no_urut
from table_master) a
where a.no_urut between 3 and 5
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)