try:select
(select max(date) from A where id=AAAA.id) as max_date,
(select min(date) from (select top 2 date from A where id=AAAA.id order by date desc)) as min_date,
id
from A as AAAA
(select max(date) from A where id=AAAA.id) as max_date,
(select min(date) from (select top 2 date from A where id=AAAA.id order by date desc)) as min_date,
id
from A as AAAA
(select max(date) from A where id=AAAA.id) as max_date,
(select min(date) from (select distinct top 2 date from A where id=AAAA.id order by date desc)) as min_date,
id
from A as AAAA
(select top 1 A1.date from A A1 where A1.id=A.id order by A1.date) as max_date,(select top 1 A2.date from A A2 where A2.id=A.id
and A2.date!=(select top 1 A3.date from A A3 where A3.id=A.id order by A3.date)
order by A2.date) as sec_date,A.idfrom A Agroup by ADainelLee(¥$£ 吃肉的菜鸟 £$¥)的语句写的比我的好,看过以后长进不少!