Select a.* from TableName a, (Select DisTinct(Name),Max(DateTimeField) as Dt from Table Group by Name,Field1,Field2,Field3) b where a.Name=b.Name and a.DateTimeField=b.Dt
to: jianping0(ljp) 可这样只显示两个字段,而且所有记录的日期都变成了同一个。
SELECT Table1.* FROM (SELECT Name, MAX([Date]) as [Date] FROM Table1 GROUP BY Name) A Inner JOIN Table1 ON A.Name = BBSQ1.Name and A.Date = BBSQ1.Date还真费劲:)
同意jianping0的看法,重要的时使用group分组函数
wolfAone(¤一步一步网上爬¤) 的做法也是对的:)
select a.* from table a, (select name,max(dates) from table group by name) b where a.name=b.name and a.dates=b.dates
不过需要修改一点。 Select a.* from TableName a, (Select DisTinct(Name),Max(DateTimeField) as Dt from Table Group by Name) b where a.Name=b.Name and a.DateTimeField=b.Dt这样和我的方法其实是一样的。camel可以试试。
先谢谢各位!! 我按 jianping0(ljp) 的写了 'select 场地编号表.* from 场地编号表, (select 场地编号,max(日期) from table group by 场地编号) b where 场地编号表.场地编号=b.场地编号表 and 场地编号表.日期=b.日期'说我from 子句语法错误。 上面的table 就是关键字还是某个表明,还有各位的表b是需要先建好的还是select语句临时产生的?
to: bisc_sunny(嶈亴橆湻鑰鑷甯櫨鏅笢鐨勯潚) 我按你的写: 'Select 场地编号表.* from 场地编号表,(Select DisTinct(场地编号),Max(日期) as Dt from Table Group by 场地编号) b where 场地编号表.场地编号=b.场地编号表 and 场地编号表.日期=b.Dt'一样出错
SQL.Add('Select 场地编号表.* from 场地编号表,(Select DisTinct(场地编号),Max(日期) as Dt from 场地编号表 Group by 场地编号) b where 场地编号表.场地编号=b.场地编号表 and 场地编号表.日期=b.Dt'); 出错信息:该特定字段‘场地编号表.日期’可以参考SQL语句中from子句列表中的多个表
SELECT 场地编号表.* FROM (SELECT 场地编号, MAX([日期]) as [日期] FROM 场地编号表 GROUP BY 场地编号) A Inner JOIN 场地编号表 ON A.场地编号 = 场地编号表.场地编号 and A.日期= 场地编号表.日期这个俺刚试过,您再看看?:)
from TableName a,
(Select DisTinct(Name),Max(DateTimeField) as Dt
from Table
Group by Name,Field1,Field2,Field3) b
where a.Name=b.Name
and a.DateTimeField=b.Dt
可这样只显示两个字段,而且所有记录的日期都变成了同一个。
FROM (SELECT Name, MAX([Date]) as [Date]
FROM Table1
GROUP BY Name) A Inner JOIN
Table1 ON
A.Name = BBSQ1.Name
and A.Date = BBSQ1.Date还真费劲:)
Select a.*
from TableName a,
(Select DisTinct(Name),Max(DateTimeField) as Dt
from Table
Group by Name) b
where a.Name=b.Name
and a.DateTimeField=b.Dt这样和我的方法其实是一样的。camel可以试试。
我按 jianping0(ljp) 的写了
'select 场地编号表.* from 场地编号表, (select 场地编号,max(日期) from table group by 场地编号) b where 场地编号表.场地编号=b.场地编号表 and 场地编号表.日期=b.日期'说我from 子句语法错误。
上面的table 就是关键字还是某个表明,还有各位的表b是需要先建好的还是select语句临时产生的?
我按你的写:
'Select 场地编号表.* from 场地编号表,(Select DisTinct(场地编号),Max(日期) as Dt from Table Group by 场地编号) b where 场地编号表.场地编号=b.场地编号表 and 场地编号表.日期=b.Dt'一样出错
出错信息:该特定字段‘场地编号表.日期’可以参考SQL语句中from子句列表中的多个表
FROM (SELECT 场地编号, MAX([日期]) as [日期]
FROM 场地编号表
GROUP BY 场地编号) A Inner JOIN
场地编号表 ON
A.场地编号 = 场地编号表.场地编号
and A.日期= 场地编号表.日期这个俺刚试过,您再看看?:)