📄 ch15-03-07.aspx
字号:
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.OleDb" %>
<% Response.Expires = 0 %>
<Html>
<Head>
<Title>Ch15-03-07.aspx SELECT表达式的IN子集查询</Title>
<Script Language="VB" Runat="Server">
Sub Page_Load(Obj As Object, e As EventArgs)
Dim DSN As String, tSQL As String
' 设置使用联机字符串
DSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("/ASP/Chap14/ASP.NET网页数据库.mdb") & ";"
' 设置SQL语句
tSQL = "SELECT * FROM UserDatas WHERE UserName IN " & _
"( SELECT TOP 2 UserName FROM UserDatas " & _
" GROUP BY UserName ORDER BY UserName DESC)"
ShowResultSet(DSN, tSQL)
End Sub
</Script>
<!-- #Include Virtual="ShowResultSet.inc" -->
</Head>
<Body>
</Body>
</Html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -