<%
page_num = Request("page_num")
scale = Request("scale")
keyword = Request("keyword")
p_act = Request("p_act")
where = "WHERE 1=1 "
If p_act <> "" Then where = where & "AND p_act = "& p_act
If keyword <> "" Then where = where & "AND p_title LIKE '%"& keyword &"%'"
query = "SELECT *, total_count = COUNT(*) OVER() FROM popup_tbl "&where&" ORDER BY idx DESC "
'query = query & "OFFSET ("& page_num-1 &") * "&scale&" ROW FETCH NEXT "&scale&" ROW ONLY" '페이징'
query = query & "OFFSET "& page_num &" ROW FETCH NEXT "& scale &" ROW ONLY" '페이징'
%>
"SELECT * FROM {table_name} ORDER BY idx DESC OFFSET 1 ROW FETCH NEXT 10 ROW ONLY"