Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

12 views

select top 400 * from Posts where PostTypeId = 1 and Com...

jul 8
12 views

select avg(CommentCount) from Posts

jul 8
12 views

select avg(CommentCount) from Posts

jul 8
12 views

select avg(CommentCount) from Posts

jul 8
13 views

select Id as i from PostsWithDeleted where posttypeid = 1...

jul 8
13 views

CREATE table #yourtable ([Id] int, [Data] int, [Value] va...

jul 8
12 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
13 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
13 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
14 views

CREATE table #yourtable ([Id] int, [Date] int, [Value] va...

jul 8
14 views

CREATE table #yourtable ([Id] int, [Date] int, [Value] va...

jul 8
14 views

CREATE table #yourtable ([Id] int, [Date] int, [Value] va...

jul 8
13 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

jul 8
14 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

jul 8
13 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

jul 8
13 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
12 views

SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#]...

jul 8
11 views

SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#]...

jul 8
12 views

SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#]...

jul 8
11 views

select sum(CAST(ViewCount as bigint)) from Posts

jul 8
11 views

select max(CreationDate) from Posts;

jul 8
11 views

select max(CreationDate) from Posts;

jul 8
21 views

Breakdown of users by reputation groups

jul 8 Martin20528
13 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
13 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
12 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
12 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
11 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
14 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
12 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
14 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
12 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
13 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
14 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
14 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
13 views

CREATE table #yourtable ([Id] int, [CreationDate] int, [N...

jul 8
21 views

Breakdown of users by reputation groups

jul 8 Martin20528
1

32 views

Breakdown of users by reputation

jul 8 Martin20528
21 views

Breakdown of users by reputation groups

jul 8 Martin20528
11 views

select top 100 * from VoteTypes order by id asc

jul 8
11 views

select top 100 * from Votes order by id asc

jul 8
11 views

select top 100 * from TagSynonyms order by id asc

jul 8
11 views

select top 100 * from Tags order by id asc

jul 8
10 views

select top 100 * from SuggestedEditVotes order by id asc

jul 8
10 views

select top 100 * from SuggestedEdits order by id asc

jul 8
10 views

select top 100 * from ReviewTaskTypes order by id asc

jul 8
10 views

select top 100 * from ReviewTaskTypes order by id asc

jul 8
10 views

select top 100 * from ReviewTaskStates order by id asc

jul 8
10 views

select top 100 * from ReviewTasks order by id asc

jul 8
11 views

select top 100 * from ReviewTaskResultTypes order by id ...

jul 8
11 views

select top 100 * from ReviewTaskResults order by id asc

jul 8
11 views

select top 100 * from ReviewRejectionReasons order by id...

jul 8
11 views

select top 100 * from PostTypes order by id asc

jul 8
11 views

select top 100 * from PostTags order by postid asc

jul 8
11 views

select top 100 * from PostsWithDeleted order by id asc

jul 8
11 views

select top 100 * from PostNoticeTypes order by id asc

jul 8
10 views

select top 100 * from PostNotices order by id asc

jul 8
10 views

select top 100 * from PostLinks order by id asc

jul 8
10 views

select top 100 * from PostHistoryTypes order by id asc

jul 8
10 views

select top 100 * from PostHistory order by id asc

jul 8
8 views

select top 100 * from PostFeedback order by id asc

jul 8
8 views

select top 100 * from PendingFlags order by id asc

jul 8
13 views

SELECT PostTypeId, COUNT(*) as NrOfPosts FROM posts GROUP...

jul 8
9 views

SELECT PostTypeId, COUNT(*) as NrOfPosts FROM posts GROUP...

jul 8
12 views

SELECT PostTypeId, COUNT(*) as NrOfPosts FROM posts GROUP...

jul 8
10 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
10 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
11 views

select top 60000 * from PostsWithDeleted where PostTypeid...

jul 8
10 views

select top 60000 * from PostsWithDeleted where PostTypeid...

jul 8
10 views

select top 5 Id,DisplayName,Reputation from Users where L...

jul 8
11 views

select top 60000 * from PostsWithDeleted where PostTypeid...

jul 8
11 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
11 views

select pwd.Id, PostTypeId, ParentId, pwd.CreationDate, De...

jul 8
11 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
11 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
10 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
11 views

select pwd.Id, PostTypeId, ParentId, pwd.CreationDate, De...

jul 8
11 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
11 views

select pwd.Id, PostTypeId, ParentId, pwd.CreationDate, De...

jul 8
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
11 views

select pwd.Id, PostTypeId, ParentId, pwd.CreationDate, De...

jul 8
12 views

select pwd.Id, PostTypeId, ParentId, pwd.CreationDate, De...

jul 8
11 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
10 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
10 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
10 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
11 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8 raswamin
11 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8 raswamin
10 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
11 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8 raswamin
10 views

select pwd.Id, PostTypeId, ParentId, pwd.CreationDate, De...

jul 8
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
11 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8 raswamin
10 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
11 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
11 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
10 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
11 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8 raswamin
10 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
15 views

Java developer

jul 8
9 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
15 views

Java developer

jul 8
15 views

Java developer

jul 8
9 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
10 views

select * from users

jul 8
9 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
38 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
17 views

Python developer search

jul 8
10 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
10 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
9 views

select Id from PostsWithDeleted where posttypeid = 1 and ...

jul 8
9 views

with users as ( select DATEADD(DAY, DATEDIFF(DAY, 0, crea...

jul 8 jon.doe33167
9 views

select top 60000 * from PostsWithDeleted where PostTypeid...

jul 8

30 50 100 per page

1,531,992

queries

Q&A for people interested in the history and origins of science and mathematics

2.9k questions

3.9k answers

13k comments

193 tags

jul 5 most recent