Select TOP 100 Min(ID) AS ID,Title from TableName Group By Title Order By IDORSelect TOP 100 Max(ID) AS ID,Title from TableName Group By Title Order By ID
Select TOP 100 Min(ID) AS ID,Title from TableName Group By Title Order By IDORSelect TOP 100 Max(ID) AS ID,Title from TableName Group By Title Order By ID
你这样的两个都可以我觉得不行啊
( Select TOP 100 Min(ID) AS ID from TableName Group By Title )
( Select TOP 100 Min(ID) AS ID from Table Group By Title )
from TableName
Group By Title
Order By ID
max这个不需要用把?
你这样的两个都可以我觉得不行啊
-----------------------------------
你不要重复的Title 嘛,所以才用Max和Min的。行不行,你自己测试下就知道了。