Q&A for professional and enthusiast programmers
;with taghistory as ( select id , creationdate , userid as [User Link] from posthistory where posthistorytypeid in (3,6) and text like '%<##tag##>%' ), toptag as ( select min(creationdate) as [created] from taghistory ), toprecord as ( select * from taghistory where creationdate = (select created from toptag) ) select * from toprecord