获取数据范围内最大id

1

Please login or register to vote for this query.

(click on this box to dismiss)

GIS

Q&A for cartographers, geographers and GIS professionals

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;

Enter Parameters

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