Stack Exchange
log in
help
Stack Exchange Data Explorer
Home
Queries
Users
Compose Query
Phrancis
Registered User
member for
2018 days
seen
Oct 24 '17 at 12:24
location
age
edited
favorite
recent
IF/ELSE branching using temp table(s)
DECLARE @shell INT = 236, @sh INT = 1101, @bash INT = 133;
SELECT Tags.TagName, Tags.Count AS QuestionCount, SUM(Pos...
WITH QuestionData AS ( SELECT t.TagName, QuestionCount = ...
Versioned Language Tags (Java, C#, Python)
SELECT COUNT(Id) FROM POSTS AS q WHERE CLOSEDDATE IS NOT...
SELECT Id AS [Post Link], AcceptedAnswerId, CreationDate,...
obtain all closed questions with score < -3
obtain all closed questions with score < -3
/* Best of Code Review 2016 - Best Newcomer (answer) cate...
Best of Code Review 2016 - Best Newcomer (answer) category
Best of Code Review 2016 - Best Newcomer (question) category
Recent 1000 users
Select posts without specific tag list
SELECT TOP 100 P.Id AS [Post Link] , P.Tags , P.CreationD...
1
2
3
4
5
…
14
next
Data Explorer works best with JavaScript enabled