SELECT DISTINCT ID, DISPLAYNAME, creationDate FROM (SELEC...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cryptography

Q&A for software developers, mathematicians and others interested in cryptography

SELECT DISTINCT ID, DISPLAYNAME, creationDate 
FROM (SELECT DISTINCT users.ID, users.DISPLAYNAME, posts.creationDate FROM USERS 
JOIN POSTS ON users.id = posts.owneruserid
WHERE posts.posttypeid ='1' AND YEAR(posts.creationdate) = '2010'
INTERSECT
SELECT DISTINCT users.ID, users.DISPLAYNAME, posts.creationDate FROM USERS 
JOIN POSTS ON users.id = posts.owneruserid
WHERE posts.posttypeid ='1' AND YEAR(posts.creationdate) = '2015') X

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results