/*select top 100 * from posts order by (select reputatio...


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for professional and amateur woodworkers

/*select top 100 *  from posts
order by (select reputation from users where users.id = posts.owneruserid) desc*/

/*select top 100 * from users
where not exists(select * from posts where users.id = posts.owneruserid and

/*select * from posts where owneruserid = 42
order by creationdate desc*/

/*select top 100 * from posts as p
full join users u on p.owneruserid = u.id*/

select top 100 * from (select * from posts where score <= 100) as t
join users as u on t.owneruserid=u.id

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results