asp中，这句sql怎么写．请指点检索出age字段最大和第二大的所有记录name agexiaoming 80xiaoli 79xiaozh 53xiaow 80xiaoh 45xiaon 79即检索出所有80和79岁的人，请指点

时间：2026-02-08 05:52:00 浏览：824次

select name ,age from b where age in (select max(age) from b) union

select name,age from b where age in (select max(age) from b where age not in (select max(age) from b))

执行结果是

xiaoli 79

xiaoming 80

xiaon 79

xiaow 80

标签：检索,指点