在线求一SQL

[chengangcsdn]

表：
kfl bb_date
30 2005-01-02
50 2005-01-05
60 2005-01-10
20 2005-02-01
50 2005-02-15
求一SQL得出每月最后一天的记录
如上表则期望结果为：
60 2005-01-10
50 2005-02-15

[chengangcsdn]

UP

[chengangcsdn]

继续UP

[chengangcsdn]

我决定连续UP 5次。
1

[ken2002]

决定也帮你顶一下

[chengangcsdn]

2

[chengangcsdn]

3

[chengangcsdn]

4

[NewQger]

如果日期字段不重复可以这样
select * from tbtest where bb_date in (select max(bb_date) from tbtest group by convert(varchar(7),bb_date,120))

[DragonBill]

select * from test a
inner join (select max(bb_date) bb_date from test group by convert(varchar(7),bb_date,120) ) b on a.bb_date=b.bb_date