WaterMelon 隨手記

Select DISTINCT ItemId 
From Item

Select ItemId 
From Item
GROUP BY ItemId 

Select ItemId,CreatedDate 
From ( Select ItemId,CreatedDate , 
       ROW_NUMBER() Over (Partition By ItemId Order By CreatedDate Desc) As Sort From Item) TMP_S 
Where TMP_S.Sort=1