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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

/*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
year(creationdate)=2020)*/

/*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*/

/*with t as (select * from users where reputation>100)
select * from t as t1 join t as t2 on ...*/

/*select * from
(select * from ususers where reputation>100) as t1
join (select * from ususers where reputation>100) as t2 on ...*/

/*select top 5 id, displayname from users
intersect
select top 5 id, title from posts*/

--select case when
--(select count(*) from posts)>1 then 'aaa' else 'bbb' end

select top 10 *, reputation+score
from users as u left join posts as p on p.owneruserid = u.id

Enter Parameters

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