求查询语句

[lyjsd]

原表如下：
Department Dtime YE
01 20070220 5000
02 20070222 4200
03 20070228 8000
02 20070308 6500
03 20070310 5000
02 20070330 4700
要求查询各部门中最后（即Dtime最大）的余额，目标表如下：

Department Dtime YE
01 20070220 5000
03 20070310 5000
02 20070330 4700

谢谢指教

[paoluo]

--方法一
Select * From 表 A Where Not Exists(Select Dtime From 表 Where Department = A.Department And Dtime > A.Dtime)

--方法二
Select * From 表 A Where Dtime = (Select Max(Dtime) From 表 Where Department = A.Department)

--方法三
Select A.* From 表 A
Inner Join
(Select Department, Max(Dtime) As Dtime From 表 Group By Department) B
On A.Department = B.Department And A.Dtime = B.Dtime

[shuai45]

呵呵 写sql不难 难的是 一条sql可以写出多种方法。
paoluo(一天到晚游泳的鱼) 正解
我这也学习了

[lyjsd]

谢了