Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

20 views

Query by tag

jan 20
22 views

Query by tag

jan 20
23 views

Query by tag

jan 20
23 views

Query by tag

jan 20
23 views

Query by tag

jan 20
14 views

SELECT 'site://q/' + CAST(Id AS VARCHAR(MAX)) + '|' + CAS...

jan 20 peterh - PLEASE DELETE THIS ACCOUNT
14 views

SELECT * FROM PostsWithDeleted WHERE DeletionDate BETWEEN...

jan 20 peterh - PLEASE DELETE THIS ACCOUNT
26 views

DROP

jan 20
24 views

DROP

jan 20
26 views

DROP

jan 20
1

598 views

Count of question creation, closure and deletion events by month (quicker + smoothable)

jan 20 peterh - PLEASE DELETE THIS ACCOUNT
1

598 views

Count of question creation, closure and deletion events by month (quicker + smoothable)

jan 20 peterh - PLEASE DELETE THIS ACCOUNT
16 views

DECLARE @now DATETIME = (SELECT MAX(CreationDate) FROM Po...

jan 20 peterh - PLEASE DELETE THIS ACCOUNT
61 views

Collective answer reputation for tag

jan 20 SO-2932052
61 views

Collective answer reputation for tag

jan 20 SO-2932052
25 views

SELECT id, PostTypeId, Title, Body, Tags,CreationDate, Sc...

jan 20 jon.doe35474
61 views

Collective answer reputation for tag

jan 20 SO-2932052
61 views

Collective answer reputation for tag

jan 20 SO-2932052
16 views

DECLARE @now DATETIME = (SELECT MAX(CreationDate) FROM Po...

jan 20 peterh - PLEASE DELETE THIS ACCOUNT
16 views

DECLARE @now DATETIME = (SELECT MAX(CreationDate) FROM Po...

jan 20 peterh - PLEASE DELETE THIS ACCOUNT
16 views

DECLARE @now DATETIME = (SELECT MAX(CreationDate) FROM Po...

jan 20 peterh - PLEASE DELETE THIS ACCOUNT
25 views

SELECT id, PostTypeId, Title, Body, Tags,CreationDate, Sc...

jan 20 jon.doe35474
15 views

SELECT Id, CreationDate, Score, ViewCount, Tags, AnswerCo...

jan 20
25 views

SELECT id, PostTypeId, Title, Body, Tags,CreationDate, Sc...

jan 20 jon.doe35474
61 views

Collective answer reputation for tag

jan 20 SO-2932052
61 views

Collective answer reputation for tag

jan 20 SO-2932052
61 views

Collective answer reputation for tag

jan 20 SO-2932052
16 views

select p.Id ,p.CreationDate ,p.Score ,p.ViewCount ,p.Tags...

jan 20
15 views

SELECT count(*) FROM posts WHERE PostTypeId = 1 AND YEAR(...

jan 20
25 views

SELECT id, PostTypeId, Title, Body, Tags,CreationDate, Sc...

jan 20 jon.doe35474
15 views

select /* p.Id ,p.CreationDate ,p.Score ,p.ViewCount ,p.T...

jan 20
15 views

select /* p.Id ,p.CreationDate ,p.Score ,p.ViewCount ,p.T...

jan 20
15 views

select AVG(cast(Score as float)) from Posts where PostTyp...

jan 20 jon.doe35474
15 views

select p.Id ,p.CreationDate ,p.Score ,p.ViewCount ,p.Tags...

jan 20
15 views

select p.Id ,p.CreationDate ,p.Score ,p.ViewCount ,p.Tags...

jan 20
15 views

select AVG(cast(a.Score as float)) from Posts as a where ...

jan 20 jon.doe35474
25 views

SELECT id, PostTypeId, Title, Body, Tags,CreationDate, Sc...

jan 20 jon.doe35474
14 views

select p.Id ,p.CreationDate ,p.Score ,p.ViewCount ,p.Tags...

jan 20
14 views

select p.Id ,p.CreationDate ,p.Score ,p.ViewCount ,p.Tags...

jan 20
14 views

select p.Id ,pt.Name as PostType ,p.CreationDate ,p.Score...

jan 20
13 views

select p.Id ,p.PostTypeId ,p.CreationDate ,p.Score ,p.Vie...

jan 20
13 views

select /* Id ,PostTypeId ,CreationDate ,Score ,ViewCount ...

jan 20
25 views

SELECT id, PostTypeId, Title, Body, Tags,CreationDate FRO...

jan 20 jon.doe35474
13 views

select Id ,PostTypeId ,CreationDate ,Score ,ViewCount ,Tags

jan 20
13 views

Select*from Badges;

jan 20
15 views

select top 10 [TagName], [Count] from [Tags] order by [Co...

jan 20
14 views

select count(*) from posts where year(CreationDate) = 2019

jan 20
13 views

select count(*) from posts where year(CreationDate) = 2019

jan 20
13 views

select count(*) from posts where year(CreationDate) = 2019

jan 20
14 views

select count(*) from posts

jan 20
13 views

select count(*) from posts

jan 20
13 views

select count(*) from posts

jan 20
14 views

select count(*) from posts

jan 20
15 views

select count(*) from posts

jan 20
13 views

select count(*) from posts

jan 20
13 views

select count(*) from posts

jan 20
13 views

select count(*) from posts

jan 20
14 views

select count(*) from posts

jan 20
14 views

select count(*) from posts

jan 20
14 views

select count(*) from posts

jan 20
15 views

select count(*) from posts

jan 20
15 views

select count(*) from posts

jan 20
15 views

select count(*) from posts

jan 20
15 views

select count(*) from posts

jan 20
15 views

select count(*) from posts

jan 20
16 views

select count(*) from posts

jan 20
25 views

SELECT id, PostTypeId, Title, Body, Tags,CreationDate FRO...

jan 20 jon.doe35474
13 views

select p2.id from Posts p1, Posts p2 where p1.ParentId = ...

jan 20
25 views

SELECT id, PostTypeId, Title, Body, Tags FROM Posts WHERE...

jan 20 jon.doe35474
13 views

select p2.id from Posts p1, Posts p2 where p1.ParentId = ...

jan 20
25 views

All reputation for a particular tag (answers + questions)

jan 20
12 views

select p2.id from Posts p1, Posts p2 where p1.ParentId = ...

jan 20
10 views

select p2.Tags from Posts p1, Posts p2 where p1.ParentId ...

jan 20
10 views

select p2.Title from Posts p1, Posts p2 where p1.ParentId...

jan 20
10 views

select Tags from Posts where OwnerUserId = 11299053 and P...

jan 20
10 views

select count(*) from Posts where OwnerUserId = 11299053 a...

jan 20
10 views

select distinct PostTypeId from Posts where OwnerUserId =...

jan 20
12 views

select distinct PostTypeId from Posts

jan 20
10 views

select distinct PostTypeId from Posts

jan 20
10 views

select distinct PostTypeId from Posts

jan 20
10 views

select distinct PostTypeId from Posts

jan 20
10 views

select distinct PostTypeId from Posts

jan 20
10 views

select distinct PostTypeId from Posts

jan 20
12 views

select distinct PostTypeId from Posts

jan 20
13 views

select distinct PostTypeId from Posts

jan 20
13 views

select distinct PostTypeId from Posts

jan 20
11 views

SELECT TOP 10 * FROM tags ORDER BY Count DESC;

jan 20
11 views

select * from tags;

jan 20
11 views

select * from tags;

jan 20
24 views

2020 answers by users with no answers before 2020

jan 20
22 views

2020 answers by users with no answers before 2020

jan 20
22 views

2020 answers by users with no answers before 2020

jan 20
13 views

Select*from PostTypes;

jan 20
13 views

Select*from PostLinks;

jan 20
13 views

Select*from PostLinks;

jan 20
13 views

Select*from PostLinks;

jan 20
26 views

select CAST(0x307838393530344534373044304131413041303030303030304434393438 as XML)

jan 20
24 views

select CAST(0x3C3F54657374696E672075706C6F61643F3E3C666F6F3E3C2F666F6F3E as XML)

jan 20
26 views

select CAST(0x307838393530344534373044304131413041303030303030304434393438 as XML)

jan 20
13 views

select Count(Id) from Users

jan 20
61 views

Collective answer reputation for tag

jan 20 SO-2932052
61 views

Collective answer reputation for tag

jan 20 SO-2932052
14 views

select top 10 *, (select count(*) from Posts where PostTy...

jan 20
14 views

select top 10 Id, (select count(*) from Posts where PostT...

jan 20
14 views

select top 10 Id, (select count(*) from Posts where PostT...

jan 20
14 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

jan 20
14 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

jan 20
14 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

jan 20
15 views

Select*from Tags;

jan 20
14 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

jan 20
14 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

jan 20
14 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

jan 20
15 views

Select*from TagSynonyms;

jan 20
16 views

Select*from Tags;

jan 20
15 views

Select*from TagSynonyms;

jan 20
15 views

Select*from Tags;

jan 20
15 views

Select*from Tags;

jan 20
16 views

Select*from Tags;

jan 20
15 views

Select*from Tags;

jan 20
15 views

Select*from Tags;

jan 20
14 views

select top 10 * from Users order by Reputation desc

jan 20
14 views

select Id from Comments where CreationDate between '2020...

jan 20
14 views

select Location,(select count(*) from Users where Locatio...

jan 20
27 views

Accumulated reputation for tag answers

jan 20
27 views

Accumulated reputation for tag answers

jan 20
14 views

select count(*) from Users where Location is not null

jan 20
14 views

select top 100 Location from Users where Location is not ...

jan 20
14 views

select count(*) from Users where Location = 'Germany'

jan 20
15 views

Select*from Tags;

jan 20
14 views

select count(*) from Users where (CreationDate Between '2...

jan 20
14 views

select DisplayName, Location, CreationDate from Users whe...

jan 20
14 views

select DisplayName, Location from Users where (CreationDa...

jan 20
14 views

select count(*) from Users union select count(*) from Tags

jan 20
14 views

select count(*) from Users select count(*) from Posts whe...

jan 20
14 views

select count(*) from Users

jan 20
14 views

select * from Users WHERE Reputation = 10

jan 20
14 views

select count(*) from Users WHERE Reputation = 10

jan 20
14 views

select top 100 Title, Body, OwnerDisplayName, CreationDat...

jan 20
14 views

SELECT ROUND(Reputation, -1), Count(*) FROM Users GROUP B...

jan 20

30 50 100 per page

1,654,739

queries

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

3.2k questions

4.2k answers

15k comments

224 tags

jan 17 most recent