怎样实现这个查询？？？

[小时候的天空]

表名：depart_info
列名：depart_name update_time people_num f_num l_num
a 20030701 323 44 43
a 20030703 323 3 55
b 20030705 444 4 44
b 20030711 333 55 2
c 20030709 222 5 2
c 20030703 33 34 3
c 20030702 33 3 3
c 20030706 232 34 4
c 20030701 23 43 33
怎样才能根据depart_name分类，
找出同一个depart_name中update_time最接近现在的那条记录
注意：查询结果中必须包含people_num,f_num,l_num
各位老大帮帮忙！！！

[klbt]

select depart_name,people_num,f_num,maxl_num
from depart_info a
where update_time=(select max(update_time) from depart_info b
where b.depart_name=a.depart_name and
group by depart_name)

[rogery]

三楼是不是抄二楼的,英雄所见略同呀.

select depart_name,people_num,f_num,maxl_num
from depart_info a
where update_time=(select max(update_time) from depart_info b
where b.depart_name=a.depart_name and
group by depart_name)

[yl_yz]

按klbt(快乐白兔)说的把and去掉就可以了.

[zhangjing0496]

按yl_yz说的去做吧

[你的昵称已存在]

同意楼上

[小时候的天空]

谢谢，我先试一下

[小时候的天空]

实际上是下面的代码，怎么走不同啊
SELECT depart_info.depend_depart,
depart_info.depart_main,
depart_info.depart_name,
depart_info.bz_piwen,
depart_info.bz_change,
depart_info.organ_rule,
depart_info.depart_id,
bz_enterprise.fl_leader,
bz_enterprise.fl_admin,
bz_enterprise.fl_enter,
bz_enterprise.fl_labor,
bz_enterprise.lb_admin,
bz_enterprise.lb_enter,
bz_enterprise.lb_labor,
bz_enterprise.lb_leader,
bz_enterprise.update_time
FROM depart_info a,
bz_enterprise c
where a.depart_name=c.depart_name
and c.update_time=(select max(update_time) from bz_enterprise b
where b.depart_name=a.depart_name
and b.update_time=c.update_time group by b.depart_name)

[小时候的天空]

因为这些都是在数据窗口中写的，如果起别名好象过不去

[freedom2001]

同意前面几位的意见，至于老虎的问题嘛，我以前在数据窗口中写过类似的程序，别名可以通过，No problem

[小时候的天空]

up

[huangxinru]

试一下
select max(depart_name),max(people_num),max(f_num),max(l_num)
from depart_info a
where update_time=(select max(update_time) from depart_info b where b.depart_name=a.depart_name)
group by depart_name