SELECT blogid,
       username,
       dateposted,
       blog,
       category
FROM   (SELECT blogid,
               username,
               dateposted,
               blog,
               category,
               Row_number() OVER(partition BY Username ORDER BY dateposted DESC) AS rn
        FROM   blogs) t
WHERE  rn = 1
ORDER  BY username