Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

13 views

select * from Comments where UserId = 1242908

jan 13 PeterJames
33 views

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

jan 13
28 views

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

jan 13
13 views

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

jan 13
28 views

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

jan 13
33 views

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

jan 13
36 views

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

jan 13
28 views

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

jan 13
26 views

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

jan 13
35 views

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

jan 13
30 views

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

jan 13
24 views

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

jan 13
14 views

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

jan 13
1

89 views

Excellent questions that have been left unanswered for a long time

jan 13 佩奇君
1

45 views

Flags long-tine pending

jan 13 佩奇君
1

45 views

Flags long-tine pending

jan 13 佩奇君
1

108 views

Shouldn't them delete or close?

jan 13 佩奇君
32 views

Top users by location

jan 13
1

150 views

Does this question really need delete?

jan 13 佩奇君
1

150 views

Does this question really need delete?

jan 13 佩奇君
11 views

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

jan 13
1

108 views

Shouldn't them delete or close?

jan 13 佩奇君
1

108 views

Shouldn't them delete or close?

jan 13 佩奇君
14 views

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

jan 13
1

108 views

Shouldn't them delete or close?

jan 13 佩奇君
12 views

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

jan 13
1

150 views

Does this question really need delete?

jan 13 佩奇君
16 views

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

jan 13
1

150 views

Does this question really need delete?

jan 13 佩奇君
1

150 views

Does this question really need delete?

jan 13 佩奇君
1

150 views

Does this question really need delete?

jan 13 佩奇君
1

150 views

Does this question really need delete?

jan 13 佩奇君
1

150 views

Does this question really need delete?

jan 13 佩奇君
1

150 views

Does this question really need delete?

jan 13 佩奇君
1

150 views

Does this question really need delete?

jan 13 佩奇君
1

150 views

Does this question really need delete?

jan 13 佩奇君
1

150 views

Does this question really need delete?

jan 13 佩奇君
1

150 views

Does this question really need delete?

jan 13 佩奇君
118 views

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

jan 13 jon.doe46824
118 views

SELECT DisplayName FROM Users WHERE DisplayName LIKE 'Ivan'

jan 13 jon.doe46824
10 views

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

jan 13
17 views

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

jan 13
10 views

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

jan 13
12 views

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

jan 13
19 views

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

jan 13
11 views

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

jan 13
19 views

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

jan 13
10 views

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

jan 13
10 views

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

jan 13
22 views

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

jan 13
20 views

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

jan 13
118 views

SELECT * FROM Posts WHERE Id < 10

jan 13 jon.doe46824
118 views

SELECT * FROM Posts WHERE Id < 10

jan 13 jon.doe46824
118 views

SELECT * FROM Posts WHERE Id < 10

jan 13 jon.doe46824
10 views

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

jan 13
20 views

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

jan 13
22 views

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

jan 13
118 views

SELECT * FROM Tags WHERE Id < 10

jan 13 jon.doe46824
118 views

SELECT COUNT(*) FROM Tags WHERE Id < 10

jan 13 jon.doe46824
10 views

select * from Posts;

jan 13
118 views

SELECT (SELECT COUNT(*) FROM Posts ) as pc, (SELECT COUN...

jan 13 jon.doe46824

30 50 100 per page

2,285,358

queries

Q&A about the site for those interested in the geology, meteorology, oceanography, and environmental sciences

343 questions

588 answers

1.6k comments

81 tags

oct 22 most recent