jon.doe8877
|
Registered User
|
- DECLARE @UserId int = ##UserId## SELECT c.postid as [Pos...
- SELECT q.id as [Post Link], * FROM Posts a, Posts q WHERE...
- select * from comments cMe, comments cThem, posts p where...
- SELECT q.id as [Post Link], a.score FROM Posts q, Posts a...
- select q.id as [Post Link], * from posts q, posts a where...
- My Comment Score distribution
- SELECT postid as [Post Link], text FROM Comments WHERE us...
- SELECT postId as [Post Link], text FROM Comments WHERE Us...
- select postid as [Post Link], * from comments where useri...
- Average and Maximum scores
- select avg(score), postTypeId from posts where tags like ...
- New users than me with more reputation
- select postid as [Post Link], score, text from comments w...
- select postid as [Post Link] from comments where userid =...
- select posts.id as [Post Link] from posts, comments where...