Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

2 views

select count(*) from comments having SUM(score) > 100

oct 12 jon.doe45919
2 views

select count(*) from comments group by postid having SUM(...

oct 12 jon.doe45919
3 views

SELECT TOP 10 Id, Score, Title FROM Posts ORDER BY Score ...

oct 12
2 views

select count(*), SUM(score), postid from comments group b...

oct 12 jon.doe45919
2 views

select SUM(score), postid from comments group by postid h...

oct 12 jon.doe45919
6 views

SELECT TOP 10 Id, Score, Title FROM Posts ORDER BY Score;

oct 12
3 views

SELECT TOP 10 Id, Score FROM Posts ORDER BY Score;

oct 12
6 views

SELECT TOP 10 Id, Score FROM Posts ORDER BY Score;

oct 12
3 views

SELECT TOP 10 Id, Score FROM Posts ORDER BY Score;

oct 12
3 views

select SUM(score), postid from comments group by postid o...

oct 12 jon.doe45919
3 views

select * from posts join comments on comments.postid = po...

oct 12 jon.doe45919
87 views

Test

oct 12 hehee
87 views

Test

oct 12 hehee
87 views

Test

oct 12 hehee
87 views

Test

oct 12 hehee
3 views

select * from posts join comments on comments.postid = p...

oct 12 jon.doe45919
87 views

Test

oct 12 hehee
3 views

select posttypeid, SUM(score), posttypes.name from posts ...

oct 12 jon.doe45919
8 views

leaderboard

oct 12
87 views

Test

oct 12 hehee
5 views

select posttypeid, SUM(score), posttypes.name from posts ...

oct 12 jon.doe45919
87 views

Test

oct 12 hehee
5 views

select posttypeid, SUM(score) from posts group by posttyp...

oct 12 jon.doe45919
10 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
5 views

select * from PostTypes

oct 12 jon.doe45919
5 views

select PostTypeId from posts where Id = 1

oct 12 jon.doe45919
11 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
12 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
5 views

select count(*) from posts where creationdate between '20...

oct 12 jon.doe45919
87 views

Test

oct 12 hehee
5 views

select * from posts where creationdate between '2023-03-0...

oct 12 jon.doe45919
7 views

select * from posts where answercount = (select MAX(answe...

oct 12 jon.doe45919
6 views

select id, (select MAX(answercount) from posts) from posts

oct 12 jon.doe45919
15 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
14 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
7 views

select id, (select MAX(answercount) from posts) from posts

oct 12 jon.doe45919
9 views

select * from posts order by answercount desc

oct 12 jon.doe45919
87 views

Test

oct 12 hehee
16 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
9 views

select MAX(answercount) from posts

oct 12 jon.doe45919
9 views

SELECT TOP 10 u.id, COUNT(*) AS activity FROM Users u LEF...

oct 12
9 views

select SUM(score) from posts where parentid = 1

oct 12 jon.doe45919
9 views

select * from posts where parentid = 1

oct 12 jon.doe45919
9 views

select SUM(score) from posts where ParentId = 1

oct 12
11 views

select * from posts where ID = 1 and posttypeid = 2

oct 12
11 views

select * from PostTypes

oct 12
11 views

select * from PostNoticeTypes

oct 12
11 views

select * from posts

oct 12
12 views

select answercount from posts where ParentId = 1

oct 12
87 views

Test

oct 12 hehee
12 views

select * from posts where id = 1

oct 12
12 views

select SUM(score) from posts where id = 1

oct 12
87 views

Test

oct 12 hehee
10 views

select answercount from posts where id = 1

oct 12
87 views

Test

oct 12 hehee
10 views

select count(*) from posts where id = 1

oct 12
87 views

Test

oct 12 hehee
10 views

select MIN(creationdate) from posts

oct 12
9 views

select creationdate from posts order by creationdate asc

oct 12
5 views

select creationdate from posts order by creationdate desc

oct 12
9 views

select creationdate from posts order by creationdate desc

oct 12
10 views

select creationdate from posts order by creationdate desc

oct 12
10 views

select creationdate from posts order by creationdate desc

oct 12
10 views

select creationdate from posts order by creationdate desc

oct 12
12 views

select creationdate from posts order by creationdate desc

oct 12
12 views

select creationdate from posts order by creationdate desc

oct 12
12 views

select creationdate from posts order by creationdate desc

oct 12
11 views

select creationdate from posts order by creationdate desc

oct 12
11 views

select creationdate from posts order by creationdate desc

oct 12
11 views

select creationdate from posts order by creationdate desc

oct 12
11 views

select creationdate from posts order by creationdate desc

oct 12
9 views

select creationdate from posts order by creationdate desc

oct 12
9 views

select creationdate from posts order by creationdate desc

oct 12
9 views

select creationdate from posts order by creationdate desc

oct 12
9 views

select creationdate from posts order by creationdate desc

oct 12
9 views

select creationdate from posts order by creationdate desc

oct 12
7 views

select creationdate from posts order by creationdate desc

oct 12
6 views

select creationdate from posts order by creationdate desc

oct 12
7 views

select creationdate from posts order by creationdate desc

oct 12
5 views

select creationdate from posts order by creationdate desc

oct 12
5 views

select creationdate from posts order by creationdate desc

oct 12
5 views

select creationdate from posts order by creationdate desc

oct 12
5 views

select creationdate from posts order by creationdate desc

oct 12
5 views

select creationdate from posts order by creationdate desc

oct 12
5 views

select creationdate from posts order by creationdate desc

oct 12
3 views

select creationdate from posts order by creationdate desc

oct 12
3 views

select creationdate from posts order by creationdate desc

oct 12
3 views

select creationdate from posts order by creationdate desc

oct 12
3 views

select creationdate from posts order by creationdate desc

oct 12
2 views

select creationdate from posts order by creationdate desc

oct 12
2 views

select creationdate from posts order by creationdate desc

oct 12
2 views

select creationdate from posts order by creationdate desc

oct 12
2 views

select creationdate from posts order by creationdate desc

oct 12
10 views

Select u.DisplayName,c.Text,p.CreationDate from Users u j...

oct 12
87 views

Test

oct 12 hehee
22 views

toop 50000 questions

oct 12 jon.doe45997
87 views

Test

oct 12 hehee
6 views

Select u.DisplayName,c.Text,max(p.CreationDate) from User...

oct 12
10 views

Select u.DisplayName,c.Text,max(p.CreationDate) from User...

oct 12
9 views

Select u.DisplayName,c.Text,max(p.CreationDate) from User...

oct 12
16 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
14 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
15 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
12 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
11 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
10 views

top 10 users who made the most comments and posts over the past 5 years

oct 12
87 views

Test

oct 12 hehee
13 views

select count(Id) from posts where ParentId = 3414789

oct 12
87 views

Test

oct 12 hehee
12 views

select count(ParentId) from posts where ParentId = 3414789

oct 12
12 views

select * from posts order by ParentId DESC

oct 12
15 views

Top 10 posts and comments

oct 12
12 views

select * from posts

oct 12
12 views

select id, reputation from users order by reputation desc

oct 12
11 views

select reputation from users order by reputation desc

oct 12
12 views

select id, MAX(reputation) from users Group by id

oct 12
12 views

select MAX(reputation) from users

oct 12
12 views

select reputation from users ORDER BY reputation DESC

oct 12
12 views

select count(*) from users

oct 12
6 views

select * from users

oct 12
12 views

select * from users

oct 12
12 views

select * from users

oct 12
12 views

select * from users

oct 12
12 views

select * from users

oct 12
11 views

select * from users

oct 12
12 views

select * from users

oct 12
12 views

select * from users

oct 12
12 views

select * from users

oct 12
12 views

select * from users

oct 12
13 views

select * from users

oct 12
28 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
28 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
27 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
26 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
24 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
24 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
25 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
24 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
26 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
26 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
19 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
26 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
26 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
24 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
25 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
24 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
24 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
26 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
27 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
28 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
28 views

Provide a list of the top 15 users who made the most posts over all time.

oct 12
22 views

SELECT TOP 100 * FROM Users WHERE Reputation > 100 ORDER ...

oct 12
11 views

SELECT * FROM Users WHERE Reputation > 100;

oct 12
22 views

SELECT * FROM Users WHERE Reputation > 100;

oct 12
22 views

export all

oct 12
12 views

SELECT p.Id, c.CreationDate as 'Comment Date', c.UserId a...

oct 12
25 views

network-wide new questions per month since 2018

oct 12 insolor
25 views

network-wide new questions per month since 2018

oct 12 insolor
23 views

new question activity per month since 2018

oct 12 insolor
13 views

WITH EUUsers AS ( SELECT Id, DisplayName, AboutMe, Location

oct 12 Kostas.Petrakis
14 views

WITH EUUsers AS ( SELECT Id, DisplayName, AboutMe, Location

oct 12 Kostas.Petrakis
13 views

WITH EUUsers AS ( SELECT Id, DisplayName, AboutMe, Location

oct 12 Kostas.Petrakis
13 views

WITH EUUsers AS ( SELECT Id, DisplayName, AboutMe, Location

oct 12 Kostas.Petrakis
13 views

WITH EUUsers AS ( SELECT Id, DisplayName, AboutMe, Location

oct 12 Kostas.Petrakis

30 50 100 per page

2,263,254

queries

Q&A about the site for alcoholic beverage aficionados and those interested in beer, wine, or spirits

98 questions

142 answers

367 comments

75 tags

mar 7 most recent