Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

8 views

select count(*) from Posts;

jan 13
25 views

SELECT distinct p.Id AS [Post Link], p.CreationDate FROM ...

jan 13 Juraj
22 views

Tags and their synonyms

jan 13
25 views

SELECT p.Id AS [Post Link], p.ClosedDate FROM Posts AS p ...

jan 13 Juraj
37 views

SELECT distinct p.Id AS [Post Link], p.CreationDate FROM ...

jan 13 Juraj
25 views

SELECT p.Id AS [Post Link], p.CreationDate FROM Posts AS ...

jan 13 Juraj
37 views

SELECT distinct p.Id AS [Post Link], p.CreationDate FROM ...

jan 13 Juraj
37 views

SELECT p.Id AS [Post Link], p.ClosedDate FROM Posts AS p ...

jan 13 Juraj
37 views

SELECT p.Id AS [Post Link], p.CreationDate FROM Posts AS ...

jan 13 Juraj
11 views

SELECT * FROM Tags

jan 13
20 views

SELECT Questions.Id AS [Post Link], Questions.Title, Ques...

jan 13
20 views

SELECT Id AS [Post Link], Body, Score FROM ( SELECT TOP 1...

jan 13
11 views

SELECT Id AS [Post Link], Body, Score FROM ( SELECT TOP 1...

jan 13
20 views

SELECT Id AS [Post Link], Body, Score FROM ( SELECT TOP 1...

jan 13
20 views

SELECT Questions.Id AS [Post Link], Questions.Title, Ques...

jan 13
23 views

Most Views (by tag)

jan 13
21 views

SELECT TOP 100 Questions.Id AS [Post Link], Questions.Tit...

jan 13
22 views

Most Views (by tag)

jan 13
21 views

Most Views (by tag)

jan 13
22 views

SELECT Id AS [Post Link], Body, Score FROM ( SELECT TOP 1...

jan 13
11 views

SELECT Id AS [Post Link], Body, Score FROM ( SELECT TOP 1...

jan 13
22 views

SELECT Id AS [Post Link], Body, Score FROM ( SELECT TOP 1...

jan 13
21 views

SELECT Id AS [Post Link], Body, Score FROM ( SELECT TOP 1...

jan 13
20 views

SELECT Id AS [Post Link], Body, Score FROM ( SELECT TOP 1...

jan 13
20 views

SELECT Id AS [Post Link], Body, Score FROM ( SELECT TOP 1...

jan 13
1

55 views

Excellent questions that have been left unanswered for a long time

jan 13 佩奇君
1

55 views

Excellent questions that have been left unanswered for a long time

jan 13 佩奇君
1

55 views

Excellent questions that have been left unanswered for a long time

jan 13 佩奇君
33 views

Excellent questions that have been left unanswered for a long time

jan 13 佩奇君
31 views

Excellent questions that have been left unanswered for a long time

jan 13
21 views

Excellent questions that have been left unanswered for a long time

jan 13
31 views

Excellent questions that have been left unanswered for a long time

jan 13
33 views

Excellent questions that have been left unanswered for a long time

jan 13
1

55 views

Excellent questions that have been left unanswered for a long time

jan 13
23 views

Most Views (by tag)

jan 13
22 views

Most Views (by tag)

jan 13
11 views

select top 100 * from Posts where CreationDate > '2025-01...

jan 13
12 views

SELECT p.id as [Post Link], p.title, p.score FROM PostsWi...

jan 13 Vincent.Thacker
14 views

select p.score , p.id as [Post Link] from posts p inner j...

jan 13
1

642 views

Profile spam - seedy

jan 13 Scortchi
1

856 views

Profile spam - generic

jan 13 Scortchi
1

856 views

Profile spam - generic

jan 13 Scortchi
1

856 views

Profile spam - generic

jan 13 Scortchi
1

856 views

Profile spam - generic

jan 13 Scortchi
24 views

SELECT TOP 75 q.Id AS [QuestionId], q.Title, q.Score, a.I...

jan 13
14 views

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

jan 12
13 views

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

jan 12
13 views

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

jan 12
22 views

select * from Posts p where p.CreationDate >= '2025-01-10...

jan 12
12 views

select * from Posts p where p.CreationDate >= '2025-01-10...

jan 12
22 views

select * from Posts p where p.CreationDate >= '2025-01-10...

jan 12
13 views

select p.Title, p.Tags, p.CreationDate from Posts p where...

jan 12
23 views

select p.Title, p.Tags from Posts p where p.CreationDate ...

jan 12
26 views

select p.Title, p.Tags, p.CreationDate from Posts p where...

jan 12
25 views

select p.Title, p.Tags, p.CreationDate from Posts p where...

jan 12
24 views

select p.Title, p.Tags, p.CreationDate from Posts p where...

jan 12
25 views

select p.Title, p.Tags from Posts p where CreationDate >=...

jan 12
27 views

select p.Title, p.Tags from Posts p where CreationDate >=...

jan 12
23 views

select p.Title, p.Tags from Posts p where CreationDate >=...

jan 12
13 views

select p.Title, p.Tags from Posts p where p.CreationDate ...

jan 12
23 views

select p.Title, p.Tags from Posts p where p.CreationDate ...

jan 12
27 views

select p.Title, p.Tags from Posts p where p.CreationDate ...

jan 12
25 views

select p.Title, p.Tags from Posts p where p.CreationDate ...

jan 12
24 views

select p.Title, p.Tags from Posts p where p.CreationDate ...

jan 12
25 views

select p.Title, p.Tags from Posts p where p.CreationDate ...

jan 12
26 views

select p.Title, p.Tags from Posts p where p.CreationDate ...

jan 12
23 views

select p.Title, p.Tags from Posts p where p.CreationDate ...

jan 12
24 views

SELECT TOP 75 q.Id AS [QuestionId], q.Title, q.Score, a.I...

jan 12
9 views

SELECT TOP 30 q.Id AS [QuestionId], q.Title, q.Score, a.I...

jan 12
24 views

SELECT TOP 30 q.Id AS [QuestionId], q.Title, q.Score, a.I...

jan 12
24 views

SELECT TOP 30 q.Id AS [QuestionId], q.Title, q.Score, a.I...

jan 12
22 views

SELECT count(u."Id"), count(v."UserId"), count(*) FROM "V...

jan 12
13 views

SELECT count("UserId") FROM "Votes" WHERE "VoteTypeId" IN...

jan 12
22 views

SELECT count("UserId") FROM "Votes" WHERE "VoteTypeId" IN...

jan 12
20 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
22 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
20 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
24 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
20 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
24 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
21 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
22 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
23 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
11 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
23 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
22 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
21 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
24 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
20 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
24 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
20 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
22 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
20 views

SELECT YEAR(p.CreationDate) AS [Year], COUNT(*) AS [PostC...

jan 12
24 views

select Tags from Posts where Id<= 1000

jan 12
11 views

select Tags from Posts where Id<= 1000

jan 12
24 views

select Tags from Posts where Id<= 1000

jan 12
76 views

Search only the deleted posts

jan 12 Sithila.Somaratne
76 views

Search only the deleted posts

jan 12 Sithila.Somaratne
76 views

Search only the deleted posts

jan 12 Sithila.Somaratne
76 views

Search only the deleted posts

jan 12 Sithila.Somaratne
24 views

Posts by a deleted user

jan 12 rene
26 views

Posts by a deleted user

jan 12 rene
23 views

Posts by a deleted user

jan 12 rene
24 views

Posts by a deleted user

jan 12 rene
23 views

Posts by a deleted user

jan 12 rene
22 views

Posts by a deleted user

jan 12 rene
12 views

SELECT * FROM Posts WHERE Tags LIKE '%database%' and Tags...

jan 12
26 views

Duplicate Questions Count per Month

jan 12
31 views

Duplicate Questions Count per Month

jan 12
27 views

Duplicate Questions Count per Month

jan 12
36 views

Duplicate Questions Count per Month

jan 12
14 views

SELECT DATEADD(MONTH, -2, GETDATE() + 1)

jan 12 Vlassy
14 views

SELECT p1.Id AS QuestionId1, p2.Id AS QuestionId2, p1.Cre...

jan 12
15 views

SELECT p1.Id AS QuestionId1, p2.Id AS QuestionId2, p1.Cre...

jan 12
30 views

SELECT Questions.Id AS QuestionId, Questions.Title AS Que...

jan 12 jon.doe46811
27 views

SELECT Questions.Id AS QuestionId, Questions.Title AS Que...

jan 12 jon.doe46811
18 views

SELECT TOP 10 Posts.Id AS PostId, Posts.Title AS Question...

jan 12
27 views

SELECT TOP 10 Posts.Id AS PostId, Posts.Title AS Question...

jan 12
30 views

SELECT TOP 10 Posts.Id AS PostId, Posts.Title AS Question...

jan 12
63 views

SELECT p.Id AS PostId,p.Body,p.Title,p.Tags,p.CreationDat...

jan 12 jon.doe46109
63 views

SELECT p.Id AS PostId,p.Body,p.Title,p.Tags,p.CreationDat...

jan 12 jon.doe46109
63 views

SELECT p.Id AS PostId,p.Body,p.Title,p.Tags,p.CreationDat...

jan 12 jon.doe46109
63 views

SELECT p.Id AS PostId,p.Body,p.Title,p.Tags,p.CreationDat...

jan 12 jon.doe46109
63 views

SELECT p.Id AS PostId,p.Body,p.Title,p.Tags,p.CreationDat...

jan 12 jon.doe46109
55 views

Top Python developers in Heidelberg

jan 12 colidyre
39 views

Top Python developers in Heidelberg

jan 12 colidyre
43 views

Top Python developers in Heidelberg

jan 12 colidyre
38 views

Top Python developers in Heidelberg

jan 12 colidyre
49 views

Top Python developers in Heidelberg

jan 12 colidyre
100 views

Top Python developers in Heidelberg

jan 12 colidyre
34 views

SELECT * FROM sede_databases WHERE database_name = 'Stack...

jan 12

30 50 100 per page

2,285,201

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