Select A,max(B),C from Table where ... group by A,C我用这句它的错误是: ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal. 什么原因呢? B的值可能是字符串或null。
看你的错误提示应该是字段名称的问题Select A,max(B) B,C from Table where ... group by A,C
select a,max(b) from table where b is not null group by a
不对啊,我现在也要输出那些null的。比如: a b mm1 mm2 as mm3 mm4 mm4 dfd这样我的输出结果要是: mm1 as mm3 mm4 dfd 也就是输出有值的,没有值的话就输出没有的。
select * from table1 where rowid in (select max(rowid) from Table1 group by a)
select max(Proerty1),name from aa group by name;
(select Name,Max(property1) property1,max(rowid) from Table1 group by Name)
select * from Table1 where rowid in
select max(rowid) from Table1 group by name)
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal. 什么原因呢?
B的值可能是字符串或null。
a b
mm1
mm2 as
mm3
mm4
mm4 dfd这样我的输出结果要是:
mm1 as
mm3
mm4 dfd
也就是输出有值的,没有值的话就输出没有的。