27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT
DISTINCT
TOP 12
ta.id AS tId,ta.Images_Small AS tImg,
ta.Train_Title AS tTitle,tc.Apply_Number
FROM
Template_Train AS ta LEFT JOIN
Template_Count AS tc ON (tc.Template_Id = ta.id)
AND TC.ID=(select MIN(ID) from Template_Count where Template_Id=tc.Template_Id)
ORDER BY tc.Apply_Number DESC
SELECT
DISTINCT
TOP 12
ta.id AS tId,ta.Images_Small AS tImg,
ta.Train_Title AS tTitle,tc.Apply_Number
FROM
Template_Train AS ta LEFT JOIN
Template_Count AS tc ON (tc.Template_Id = ta.id)
AND ID=(select MIN(ID) from Template_Count where Template_Id=tc.Template_Id)
ORDER BY tc.Apply_Number DESC
SELECT DISTINCT TOP 12 ta.id AS tId,ta.Images_Small AS tImg,ta.Train_Title AS tTitle,tc.Apply_Number
FROM Template_Train AS ta LEFT JOIN Template_Count AS tc
ON tc.Template_Id = ta.id
where not exists(select 1 from Template_Count where Template_Id=tc.Template_Id and id>tc.id)
ORDER BY tc.Apply_Number DESC