比如我要取得一系列产品中价格的最大值是多小,最小值是多小?价格字段为 cp_jg
sql="select * from cp *********"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1

sql语句里用max和min

<%
dim adoConn
dim ConString
dim adoRst
set adoConn = Server.CreateObject("AdoDB.Connection")
ConString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info = False;" _
& "Data Source = D:\mdb\NorthWind.mdb;Jet OlEDB:DataBase Password=123456"

adoConn.Open ConString
dim sql
Sql = "Select Max(OrderID) , Min(OrderID) From Orders"

set adoRst = adoConn.Execute(sql)

Response.Write (adoRst(0))
Response.Write (" ")
ResPonse.Write (adoRst(1))

adoRst.close
adoconn.close

%>

max,min可以，也可以先排序，然后选第一个

select top 1 * from yourTable order by com(字段) desc(降序)

是呀,我怎么就没想到呢
谢谢二位了