Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

63 views

select * from Comments where UserId = 1242908

jan 13 PeterJames
19 views

select * from Comments where UserId = 1242908

jan 13 PeterJames
37 views

SELECT * From "PostHistory" ph WHERE "PostId" = 1879635

jan 13
36 views

SELECT * From "PostHistory" ph WHERE "Id" = 5742645

jan 13
16 views

SELECT * From "PostHistory" ph where "PostHistoryTypeId" ...

jan 13
36 views

SELECT * From "PostHistory" ph where "PostHistoryTypeId" ...

jan 13
37 views

SELECT * From "PostHistory" ph where "PostHistoryTypeId" ...

jan 13
41 views

SELECT * From "PostHistory" ph where "PostHistoryTypeId" ...

jan 13
39 views

SELECT * From "PostHistory" ph where "PostHistoryTypeId" ...

jan 13
36 views

SELECT * From "PostHistory" ph where "PostHistoryTypeId" ...

jan 13
38 views

SELECT * From "PostHistory" ph where "PostHistoryTypeId" ...

jan 13
39 views

SELECT * From "PostHistory" ph where "PostHistoryTypeId" ...

jan 13
31 views

SELECT * From "PostHistory" ph where "PostHistoryTypeId" ...

jan 13
20 views

SELECT count(CASE WHEN "UserId" IS NULL AND "UserDisplayN...

jan 13
1

104 views

Excellent questions that have been left unanswered for a long time

jan 13 佩奇君
1

59 views

Flags long-tine pending

jan 13 佩奇君
1

59 views

Flags long-tine pending

jan 13 佩奇君
1

150 views

Shouldn't them delete or close?

jan 13 佩奇君
54 views

Top users by location

jan 13
1

168 views

Does this question really need delete?

jan 13 佩奇君
1

168 views

Does this question really need delete?

jan 13 佩奇君
13 views

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

jan 13
1

150 views

Shouldn't them delete or close?

jan 13 佩奇君
1

150 views

Shouldn't them delete or close?

jan 13 佩奇君
20 views

SELECT * From "PostHistory" ph LEFT OUTER JOIN "Posts" p ...

jan 13
1

150 views

Shouldn't them delete or close?

jan 13 佩奇君
15 views

SELECT * From "PostHistory" where "PostHistoryTypeId" = 1...

jan 13
1

168 views

Does this question really need delete?

jan 13 佩奇君
19 views

SELECT count(CASE WHEN "UserId" IS NULL AND "UserDisplayN...

jan 13
1

168 views

Does this question really need delete?

jan 13 佩奇君
1

168 views

Does this question really need delete?

jan 13 佩奇君
1

168 views

Does this question really need delete?

jan 13 佩奇君
1

168 views

Does this question really need delete?

jan 13 佩奇君
1

168 views

Does this question really need delete?

jan 13 佩奇君
1

168 views

Does this question really need delete?

jan 13 佩奇君
1

168 views

Does this question really need delete?

jan 13 佩奇君
1

168 views

Does this question really need delete?

jan 13 佩奇君
1

168 views

Does this question really need delete?

jan 13 佩奇君
1

168 views

Does this question really need delete?

jan 13 佩奇君
121 views

SELECT DisplayName FROM Users WHERE DisplayName LIKE '%Iv...

jan 13 jon.doe46824
121 views

SELECT DisplayName FROM Users WHERE DisplayName LIKE 'Ivan'

jan 13 jon.doe46824
11 views

SELECT TOP 100000 P.Id AS [Post ID], CONCAT('https://work...

jan 13
19 views

SELECT TOP 100000 P.Id AS [Post ID], CONCAT('https://work...

jan 13
11 views

SELECT TOP 100000 P.Id AS [Post ID], CONCAT('https://work...

jan 13
13 views

SELECT TOP 100000 P.Id AS [Post ID], CONCAT('https://work...

jan 13
21 views

select top 500 [Id] as [Post Link], Score, ViewCount, ROW...

jan 13
12 views

select top 500 [Id] as [Post Link], Score, ViewCount, ROW...

jan 13
21 views

select top 500 [Id] as [Post Link], Score, ViewCount, ROW...

jan 13
11 views

select top 500 [Id] as [Post Link], Score, Rank() over (O...

jan 13
12 views

SELECT TOP 100000 P.Id AS [Post ID], CONCAT('https://work...

jan 13
25 views

select DATETRUNC(mm, CreationDate), count(*) from Posts g...

jan 13
22 views

select month(CreationDate), count(*) from Posts group by ...

jan 13
121 views

SELECT * FROM Posts WHERE Id < 10

jan 13 jon.doe46824
121 views

SELECT * FROM Posts WHERE Id < 10

jan 13 jon.doe46824
121 views

SELECT * FROM Posts WHERE Id < 10

jan 13 jon.doe46824
10 views

select CreationDate, count(*) from Posts group by Creatio...

jan 13
22 views

select CreationDate, count(*) from Posts group by Creatio...

jan 13
25 views

select CreationDate, count(*) from Posts group by Creatio...

jan 13
11 views

select CreationDate, count(*) from Posts group by Creatio...

jan 13
11 views

select CreationDate, count(*) from Posts group by Creatio...

jan 13
12 views

select CreationDate, count(*) from Posts group by Creatio...

jan 13
12 views

select CreationDate, count(*) from Posts group by Creatio...

jan 13
11 views

select CreationDate, count(*) from Posts group by Creatio...

jan 13
13 views

select CreationDate, count(*) from Posts group by Creatio...

jan 13
12 views

select CreationDate, count(*) from Posts group by Creatio...

jan 13
121 views

SELECT * FROM Tags WHERE Id < 10

jan 13 jon.doe46824
121 views

SELECT COUNT(*) FROM Tags WHERE Id < 10

jan 13 jon.doe46824
10 views

select * from Posts;

jan 13

30 50 100 per page

2,285,459

queries

Q&A for developers and researchers interested in open data

6.3k questions

7.3k answers

12k comments

314 tags

jan 11 most recent