SELECT MIN(S.Price) AS MinPrice, MAX(S.Price) AS MaxPrice FROM Services AS S WHERE ',' + S.CategoryID + ',' LIKE '%,20,%'
Sırala
SELECT TOP 4 S.ID, S.EntityID, S.UserID, S.Title, S.Price, S.Rating, S.ReviewCount, S.CategoryID, (SELECT MIN(S1.Price) FROM Services AS S1) AS MinPrice, (SELECT MAX(S1.Price) FROM Services AS S1) AS MaxPrice, C.UserName AS Username, C.SocialPicture AS ProfileImageURL FROM Services AS S CROSS APPLY dbo.SplitString(S.Pods, ',') AS SplitPods LEFT JOIN Customer C ON S.UserID = C.ID WHERE ',' + S.CategoryID + ',' LIKE '%,20,%' ORDER BY S.CreatedDate DESC