Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

19 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
19 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
21 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
21 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
21 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
21 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
21 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
11 views

select PostTypeId, SUM(Score) from posts where id<50 grou...

jan 16
11 views

select * from posts where id<50

jan 16
11 views

select * from posts where id<10

jan 16
13 views

select * from posts where id=1

jan 16
11 views

select * from posts where id=1

jan 16
11 views

select * from posts where id=1

jan 16
11 views

select * from posts where id=1

jan 16
21 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
21 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
21 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
21 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
21 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
20 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
19 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
19 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
19 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
18 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
19 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
16 views

select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

jan 16
12 views

SELECT DISTINCT(u.Id), u.Reputation FROM Posts p JOIN Co...

jan 16
11 views

select count(*) from posts

jan 16
11 views

SELECT u.Id, u.Reputation FROM Posts p JOIN Comments c O...

jan 16
11 views

select * from posts where id < 200

jan 16
11 views

select * from posts where id < 200

jan 16
11 views

select * from posts where id < 200

jan 16
12 views

select * from posts where id < 100

jan 16
12 views

SELECT * FROM posttypes;

jan 16
12 views

SELECT * FROM posttypes;

jan 16
12 views

SELECT * FROM posttypes;

jan 16
12 views

SELECT * FROM posttypes;

jan 16
12 views

SELECT * FROM posttypes;

jan 16
12 views

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

jan 16
10 views

SELECT TOP 10 * FROM Posts ORDER By FavoriteCount DESC;

jan 16
12 views

SELECT TOP 10 * FROM Posts ORDER By FavoriteCount DESC;

jan 16
12 views

SELECT TOP 10 * FROM Posts ORDER By FavoriteCount DESC;

jan 16
12 views

SELECT TOP 10 * FROM Posts ORDER By FavoriteCount DESC;

jan 16
13 views

SELECT TOP 10 * FROM tags ORDER BY Count DESC

jan 16
13 views

SELECT TOP 10 * FROM tags ORDER BY Count DESC

jan 16
13 views

SELECT TOP 10 * FROM Posts ORDER BY ViewCount DESC;

jan 16
13 views

SELECT TOP 10 * FROM tags ORDER BY Count DESC;

jan 16
13 views

SELECT TOP 10 * FROM tags ORDER BY Count DESC;

jan 16
13 views

SELECT TOP 10 * FROM tags ORDER BY Count DESC;

jan 16
13 views

SELECT TOP 10 * FROM tags ORDER BY Count DESC;

jan 16
14 views

select * from users

jan 16
14 views

select TOP 10 * from posts p where p.tags like '%<##tag?...

jan 16
19 views

Unused pairs of tags

jan 16 samm82
19 views

Unused pairs of tags

jan 16 samm82
14 views

select * from Posts

jan 16
14 views

select * from tags

jan 16
14 views

select * from tags

jan 16
20 views

Unused pairs of tags

jan 16
13 views

SELECT Id AS [Post Link], (SELECT MAX(v) FROM (VALUES (Cl...

jan 16
4.6k views

Search comments

jan 16 Dour High Arch
12 views

SELECT * FROM TagSynonyms WHERE SourceTagName like '%sql%...

jan 16
12 views

SELECT * FROM TagSynonyms WHERE TargetTagName like '%sql%'

jan 16
13 views

select Id, SUBSTRING(Title,0,60) from posts order by len...

jan 16
15 views

select * from PostLinks where LinkTypeId=3

jan 16
16 views

select * from PostLinks where PostId=9229645 and LinkType...

jan 16
14 views

select * from PostLinks where LinkTypeId=3

jan 16
14 views

select count(*) from PostLinks where LinkTypeId=3

jan 16
14 views

SELECT * FROM Tags WHERE TagName like '%sql%'

jan 16
14 views

select * from PostLinks

jan 16
14 views

select * from PostLinks

jan 16
14 views

select * from PostLinks

jan 16
16 views

select * from PostLinks

jan 16
15 views

select * from PostLinks

jan 16
13 views

SELECT * FROM Tags

jan 16
14 views

SELECT Id, Title, Body, Tags, viewCount, AnswerCount, Clo...

jan 16
15 views

SELECT year, count(*) FROM ( SELECT YEAR(ClosedDate) as y...

jan 16
78 views

Question 1 - Applicant Exercise

jan 16 jon.doe35017
41 views

Question 1 - Applicant Exercise w/Notes

jan 16 jon.doe35017
15 views

SELECT cast(ClosedDate as date), count(*) FROM Posts WHER...

jan 16
14 views

SELECT cast(ClosedDate as date) FROM Posts WHERE lower(Ta...

jan 16
15 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
78 views

Question 1 - Applicant Exercise

jan 16 jon.doe35017
15 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
15 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
14 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
15 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
15 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
14 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
13 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
14 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
12 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
12 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
13 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
13 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
13 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
13 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
12 views

SELECT min(ViewCount), max(ViewCount), min(ClosedDate), m...

jan 16
21 views

Hit and Run -- Version 2

jan 16
12 views

SELECT min(ViewCount), max(ViewCount) FROM Posts WHERE lo...

jan 16
12 views

select top 10 * from posts

jan 16
13 views

SELECT min(ViewCount), max(ViewCount) FROM Posts WHERE lo...

jan 16
15 views

SELECT TOP 500 q.Title, q.Id, q.Tags, q.Score, a.Body FRO...

jan 15 Thomsch
15 views

SELECT TOP 500 q.Title, q.Id, q.Tags, q.Score, a.Body FRO...

jan 15 Thomsch
15 views

SELECT TOP 20 q.Title, q.Id, q.Tags, q.Score, a.Body FROM...

jan 15 Thomsch
13 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
13 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
12 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
12 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
13 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
13 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
13 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
13 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
15 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
15 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
14 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
15 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
15 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
14 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
13 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
14 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
12 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
12 views

SELECT min(AnswerCount), max(AnswerCount), min(ViewCount)...

jan 15
16 views

SELECT TOP 500 q.Title, q.Id, q.Tags, q.Score, a.Body FRO...

jan 15 Thomsch
16 views

SELECT TOP 500 q.Title, q.Id, q.Tags, q.Score, a.Body FRO...

jan 15 Thomsch
16 views

SELECT TOP 20 q.Title, q.Id, q.Tags, q.Score, a.Body FROM...

jan 15 Thomsch
13 views

SELECT Id, Title, Body, Tags, AnswerCount, ViewCount, Com...

jan 15
25 views

Ripe zombies

jan 15
78 views

Question 1 - Applicant Exercise

jan 15 jon.doe35017
78 views

Question 1 - Applicant Exercise

jan 15 jon.doe35017
15 views

select top 20 q.Title, q.Id, q.Tags, q.Score, a.Body from...

jan 15
14 views

SELECT Id, Title, Body, Tags, AnswerCount, ViewCount, Com...

jan 15
27 views

WITH Raw AS ( SELECT Id, CreationDate, LAG(CreationDate) ...

jan 15 peterh - PLEASE DELETE THIS ACCOUNT
78 views

Question 1 - Applicant Exercise

jan 15 jon.doe35017
13 views

SELECT Id, Title, Body, Tags, AnswerCount, ViewCount, Com...

jan 15
14 views

SELECT Id, Title, Body, Tags, AnswerCount, ViewCount, Com...

jan 15
13 views

SELECT Id, Title, Body, Tags, AnswerCount, ViewCount, Com...

jan 15
27 views

WITH Raw AS ( SELECT Id, CreationDate, LAG(CreationDate) ...

jan 15 peterh - PLEASE DELETE THIS ACCOUNT
27 views

WITH Raw AS ( SELECT Id, CreationDate, LAG(CreationDate) ...

jan 15 peterh - PLEASE DELETE THIS ACCOUNT
78 views

Question 1 - Applicant Exercise

jan 15 jon.doe35017
14 views

WITH Raw AS ( SELECT Id, CreationDate, LAG(CreationDate) ...

jan 15 peterh - PLEASE DELETE THIS ACCOUNT
14 views

WITH Raw AS ( SELECT Id, CreationDate, LAG(CreationDate) ...

jan 15 peterh - PLEASE DELETE THIS ACCOUNT
33 views

SELECT TOP 1000 * FROM Posts p

jan 15 jon.doe35017
78 views

Question 1 - Applicant Exercise

jan 15 jon.doe35017
78 views

Question 1 - Applicant Exercise

jan 15 jon.doe35017
78 views

Question 1 - Applicant Exercise

jan 15 jon.doe35017
11 views

SELECT COUNT(u.Id) FROM Users u WHERE u.Reputation >= 15;

jan 15

30 50 100 per page

1,652,944

queries

Q&A about the site for scholars and enthusiasts of literature

402 questions

815 answers

3.2k comments

88 tags

jan 17 most recent