Q&A about the site for members of the workforce navigating the professional setting
SELECT p.id ,s.text FROM posts p LEFT JOIN( SELECT c.postid ,c.text ,ROW_NUMBER () OVER ( ORDER BY (c.creationdate) DESC) rn FROM comments c) s ON s.postid = p.id where rn = 1;