last users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском

Вопросы и ответы для программистов

select id as [User Link] from users
inner join 
(
 select Count(p.id) postcount, p.OwnerUserId  
 from Posts p
 where p.posttypeid = 1
 group by p.OwnerUserId
 having Count(p.id) < 3
 ) postcount on postcount.OwnerUserId = users.id
where creationdate >= DATEADD(month, -1, GETDATE())

select id as [User Link] from users
inner join 
(
 select Count(p.id) postcount, p.OwnerUserId  
 from Posts p
 where p.posttypeid = 1
 group by p.OwnerUserId
 having Count(p.id) < 3
 ) postcount on postcount.OwnerUserId = users.id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results