0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for amateur radio enthusiasts

select top 15
users.id, users.displayname,
count(*) as postcount
from users
join posts on users.id=posts.owneruserid
group by users.id,users.displayname
order by postcount desc;

select top 10
users.id, users.displayname
from users

view current version

edited nov 3

created nov 3 jon.doe46178