我有一个表
strClass
字段结构为:
StrName strTitle StrId
kkk P-123456 1
kkk p-456 4
zzz p-456 5
zzz p-987 1
jjj p-7894 2
jjj p-98i 3怎么提取字段StrName的最大的strId值,(StrName不能提出重复值)提出结果为:
StrName strTitle StrId
kkk p-456 4
zzz p-456 5
jjj p-98i 3怎么提取字段StrName的最大的strId值,(StrName不能提出重复值)
strClass
字段结构为:
StrName strTitle StrId
kkk P-123456 1
kkk p-456 4
zzz p-456 5
zzz p-987 1
jjj p-7894 2
jjj p-98i 3怎么提取字段StrName的最大的strId值,(StrName不能提出重复值)提出结果为:
StrName strTitle StrId
kkk p-456 4
zzz p-456 5
jjj p-98i 3怎么提取字段StrName的最大的strId值,(StrName不能提出重复值)
select t.strName, t.strTitle, t.strId
from
(select strName, max(strId) strId from strClass group by strName) a , strClass t
where t.strname = a.strname and t.strid = a.stri
from
(select strName, max(strId) strId from strClass group by strName) a , strClass t
where t.strname = a.strname and t.strid = a.strid