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

时间：2026-09-03 16:36:00 浏览：994次

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

标签：检索,指点