一个在asp中的sql问题

[sealor109]

现在我有一个表:picture_active
有两个字段:id 和 path

在asp中连接数据库查询该表,要得到id的最大值和最小值,并把最大值赋给变量a,最小值赋给变量b,请问在asp中这个语句应该怎么写?

[ygjwjj]

rs.open "select Max(id) a,Min(id) b from picture_active order by id desc",3,3
a=rs("a")
b=rs("b")

[sealor109]

rs.open "select Max(id) a,Min(id) b from picture_active order by id desc",3,3
a=rs("a")
b=rs("b")


3,3是什么意思啊?

[aspgreener]

select a=max(id),b=min(id) from picture_active

[hqcsx]

select top1 id from table order by id desc可以获得id的最大值.

[谢紫枫]

rs.open "select Max(id) as a,Min(id) as b from picture_active order by id desc",3,3
3,3是参数，控制读写权限等

[liuyangxuan]

。。。。

[wq99]

统一楼上的各位。
楼主是不是第一次在asp里对数据库操作。
^_^ 我也差不多

[谢紫枫]

刚才忘了写连接字符串了
rs.open "select Max(id) as a,Min(id) as b from picture_active order by id desc",CN,3,3