asp中,这句sql怎么写.请指点检索出age字段最大和第二大的所有记录name agexiaoming 80xiaoli 79xiaozh 53xiaow 80xiaoh 45xiaon 79即检索出所有80和79岁的人,请指点
的有关信息介绍如下: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