Information schema for a Table

0

Please login or register to vote for this query.

(click on this box to dismiss)

DON'T EDIT THIS QUERY! YOU HAVE LINKED TO IT FROM HERE: http://meta.stackexchange.com/a/2678/158100 REMEMBER?

Stack Overflow

Q&A for professional and enthusiast programmers

select * from (select Users.Id, Users.DisplayName, count(Comments.Id) as CountAns
from Users INNER 
JOIN Comments on Users.Id=Comments.UserId
group by Users.Id, Users.DisplayName) as table1 where table1.CountAns>20;

Enter Parameters

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