解释一下SQL语句（牛人请进）
这个是这一段的全部代码 <%
'验证登录状态
Call CheckLogin()
'获取会话
strUserID = Session("UserID")
'获取表单变量
strActionType = Trim(Request("ActionType"))
intPage = Trim(Request("Page"))
If strActionType = "AddGroup" Then
Response.Write(strActionType)
strGroupName = Trim(Request("GroupName"))
strGroupDesc = Trim(Request("GroupDesc"))
strGroupLevel = Trim(Request("GroupLevel"))
Call AddGroup(strGroupName,strGroupDesc,strGroupLevel,strUserID)
End If
'初始化分页变量
If intPage = "" Or isNumeric(intPage) = 0 Then intPage = 1
intPageSize = 10
intStartRow = (Page - 1) * intPageSize + 1
intEndRow = intPage * intPageSize
strPage_Url = "/admin/group/group_add.asp?"
'初始化SQL
Sql_Count = "select count(*) from icms_group"
Sql = "select * from (select row_.*,rownum rownum_ from(" &_
"select t1.group_id,t1.group_name,t1.group_desc,t2.real_name from icms_group t1,icms_user t2 " &_
"where t2.user_id = t1.builder_id order by t1.group_id desc" &_
") row_ where rownum <= " & intEndRow & ") where rownum_ >= " & intStartRow
'打开数据库
Call OpenDatabase()
'执行数据操作
intRecordCount = CInt(Conn.Execute(Sql_Count)(0))
Rs.Open Sql,Conn,1,1
If Not Rs.Eof Then
arrayGroup = Rs.GetRows()
Else
arrayGroup = ""
End If
Rs.Close
'关闭数据库
Call CloseDatabase()
%>
红色代码 是什么意思请解释 大概是分页查询 用标准语句怎么写 请直接
等待中
