asp中用access,请问这条sql语句怎么写？请指点

我也是刚学哦 不太懂你的意思 但知道是80 和 79的话
select * from asp where age>=79 就可以查询了
至于最大第二大 我也不知道怎么写。。

1. SQL SERVER 7: 用 TOP N (WITH TIES)
如：SELECT TOP 2 WITH TIES * FROM MYTABLE ORDER BY age;

2. ORACLE 8i: 用 ROWNUM<=N
如：SELECT * FROM MYTABLE WHERE age>= (SELECT MIN(age) FROM ( SELECT * FROM MYTABLE ORDER BY age DESC) WHERE ROWNUM<=2) ORDER BY age DESC;

语句已经测试过

SELECT TOP 2 * FROM 表名 ORDER BY age Desc