select a.*
from tablename a join (
select name, max(date) as date
from tablename) b on a.name = b.name and a.date = b.date
from tablename a join (
select name, max(date) as date
from tablename) b on a.name = b.name and a.date = b.date
解决方案 »
- 关于XP安装SQL2005标准版
- 关于用日期做条件查询的问题?
- 如何向程序返回多于1个记录集?谢谢!
- 同时更新两个不同数据库的表
- SQL2000应该安装哪些组件?
- sqlsever7.0能否在单机的WINXP上安装、我装时报告只能装客户端,而不能装服务版,还有、我是装标准版还是桌面版?
- sql server2000里database里的一个库不能操作
- sql-server弱弱的问题.解决就结贴
- ★★★★★怎样获取表中第i行到第j行的数据??
- 誰能給我一些數據?
- insert into code select * from tempcode
- 能否在两个操作系统之间共享一个MS-SQL Server?
from table1 as a
inner join
(
select name,max(date) as mdt
from table1
group by name) as b on a.date = b.mdt