0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
  U.DISPLAYNAME
 ,COALESCE(P.TITLE, 'Unknown') AS 'TITLE'
 ,CASE WHEN(ROW_NUMBER() OVER(PARTITION BY U.ID ORDER BY P.CREATIONDATE)) = 1
       THEN 'Y'
       ELSE 'N'
  END AS 'FIRST POST?'
FROM POSTS AS P
  INNER JOIN USERS AS U
    ON P.OWNERUSERID = U.ID
    AND P.OWNERUSERID IN (610455, 174910);

fork query

edited sep 1 16

created aug 14 16 anonymous