1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select * from 
(
  select * from Posts
  order by Id desc
  offset 20000 rows fetch next 10000 rows only
) #posts
where AnswerCount = 0
and ClosedDate is null
and Score > 0
and (
  Tags like '%javascript%' or
  Tags like '%css%' or
  Tags like '%html%' 
)

fork query

edited oct 15

created oct 15 async.await