페이징 쿼리
페이징 쿼리 . 1. NOT IN 쿼리 SELECT TOP 10 seq, thread, depth, writer, title, readcount, transdate FROM ThreadBoard WHERE seq NOT IN (SELECT Top 10 * (@page-1) seq FROM ThreadBoard ORDER BY seq DESC) ORDER BY thread DESC http://taeyo.net/lecture/NET/NetBoard09.asp 참조 2. SELECT TOP n FROM (SELECT TOP n FROM ORDER BY ... ASC) DESC SELECT * FROM ( SELECT TOP 10 * FROM ( SELECT TOP 20 seq, thread, depth, w..
ASP.NET
2008. 2. 19. 17:43
