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

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

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

Enter Parameters

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