1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and implementers of computer programming languages

SELECT COUNT(a.id), MAX(a.id)
FROM (
  SELECT TOP 800000 
         p1.id AS id
  FROM posts p1
      INNER JOIN posts p2 ON p1.acceptedanswerid = p2.id
  WHERE p1.tags LIKE '%<java>%'
        and p1.id > 0
  order by p1.id
) AS a;

fork query

created apr 23 23 jon.doe41399