[SQL] How to query sql for a newest record for each group
2018-09-14 14:47:45
SELECT t.SubcateCode, t.NewsID, t.PrintDate, t.Story, t.Headline from IRNews t INNER JOIN ( SELECT NewsID,SubcateCode, MAX(PrintDate) as MaxDate FROM IRNews WHERE CategoryCode='EVN' ...