0

Please login or register to vote for this query.

(click on this box to dismiss)

find post by id

Q&A for network engineers

-- A post
-- find post by id

select  u.displayname, 
    p.*
from
    posts p
       inner join users u
          on u.id = owneruserid
    where -- cast(p.creationdate as date) = '2013-04-30' and 
   -- p.Score<0 and
    posttypeid= 1 and
    DisplayName like 'jh%'

fork query

edited jan 11 14

created oct 31 11 anonymous