Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

20 views

SELECT p.Id, AVG(a.Score) AS AverageAnswerScore FROM Post...

dec 12
20 views

SELECT u.Id, u.Reputation FROM Users u WHERE u.Id NOT IN ...

dec 12
22 views

SELECT u.Id, u.Reputation FROM Users u WHERE u.Id NOT IN ...

dec 12
11 views

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

dec 12
10 views

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

dec 12
20 views

SELECT Id FROM Posts WHERE PostTypeId = 1 AND AnswerCount...

dec 12
2.1k views

NAADetector

dec 12 Starship
20 views

SELECT AVG(AnswerCount) FROM Posts WHERE PostTypeId = 1;

dec 12
2.1k views

NAADetector

dec 12 Starship
21 views

SELECT TOP 1 UserId FROM Comments WHERE UserId IS NOT NUL...

dec 12
20 views

SELECT TOP 1 UserId FROM Comments GROUP BY UserId ORDER B...

dec 12
2.1k views

NAADetector

dec 12 Starship
2.1k views

NAADetector

dec 12 Starship
9 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
20 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
21 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
20 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
20 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
22 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
20 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
20 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
19 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
20 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
23 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
23 views

SELECT COUNT(*) AS CommentCount FROM Comments c JOIN Post...

dec 12
27 views

Tag Names

dec 12 jon.doe46566
27 views

Tag Names

dec 12 jon.doe46566
28 views

Tag Names

dec 12 jon.doe46566
27 views

Tag Names

dec 12 jon.doe46566
27 views

Tag Names

dec 12 jon.doe46566
23 views

Tag Names

dec 12 jon.doe46566
27 views

Tag Names

dec 12 jon.doe46566
9 views

select * from Posts

dec 12
26 views

Tag Names

dec 12
25 views

Tag Names

dec 12
23 views

Tag Names

dec 12
16 views

Tag Names

dec 12
23 views

Tag Names

dec 12
25 views

Tag Names

dec 12
26 views

Tag Names

dec 12
27 views

Tag Names

dec 12
23 views

Tag Names

dec 12
27 views

Tag Names

dec 12
27 views

Tag Names

dec 12
28 views

Tag Names

dec 12
27 views

Tag Names

dec 12
27 views

Tag Names

dec 12
10 views

select * from Posts;

dec 12
17 views

Top Users by Country

dec 12
8 views

SELECT u.Location as Location, -- Users テーブルのエイリアス "u" t....

dec 12
17 views

WITH MatchedTags AS ( SELECT DISTINCT TagName FROM Tags W...

dec 12
18 views

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

dec 12
20 views

WITH MatchedTags AS ( SELECT DISTINCT TagName FROM Tags W...

dec 12
9 views

WITH MatchedTags AS ( SELECT DISTINCT TagName FROM Tags W...

dec 12
20 views

WITH MatchedTags AS ( SELECT DISTINCT TagName FROM Tags W...

dec 12
17 views

WITH MatchedTags AS ( SELECT DISTINCT TagName FROM Tags W...

dec 12
17 views

NAADetector

dec 12
8 views

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

dec 12
18 views

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

dec 12
8 views

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

dec 12
16 views

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

dec 12
8 views

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

dec 12
16 views

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

dec 12
16 views

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

dec 12
15 views

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

dec 12
8 views

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

dec 12
15 views

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

dec 12
16 views

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

dec 12
15 views

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

dec 12
7 views

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

dec 12
15 views

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

dec 12
14 views

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

dec 12
7 views

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

dec 12
14 views

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

dec 12
14 views

Old Potential Non-Answers (OPNA)

dec 12
14 views

Old Potential Non-Answers (OPNA)

dec 12
14 views

Old Potential Non-Answers (OPNA)

dec 12
15 views

Old Potential Non-Answers (OPNA)

dec 12
14 views

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

dec 12
7 views

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

dec 12
14 views

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

dec 12
0 views

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

dec 12
0 views

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

dec 12
0 views

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

dec 12
0 views

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

dec 12
0 views

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

dec 12
7 views

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

dec 12
7 views

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

dec 12
14 views

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

dec 12
13 views

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

dec 12
14 views

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

dec 12
14 views

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

dec 12
14 views

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

dec 12
14 views

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

dec 12
14 views

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

dec 12
7 views

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

dec 12
14 views

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

dec 12
14 views

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

dec 12
14 views

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

dec 12
14 views

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

dec 12
14 views

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

dec 12
13 views

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

dec 12
14 views

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

dec 12
16 views

comments

dec 12
16 views

comments

dec 12
15 views

comments

dec 12
14 views

comments

dec 12
15 views

comments

dec 12
13 views

comments

dec 12
14 views

select top 50 * from Posts

dec 12
7 views

select * from Users

dec 12
14 views

select * from Users

dec 12
14 views

SELECT TOP 20000 Title, Body, Tags, Id, Score, ViewCount,...

dec 12
13 views

SELECT TOP 10000 Title, Body, Tags, Id, Score, ViewCount,...

dec 12
7 views

SELECT TOP 10000 Title, Body, Tags, Id, Score, ViewCount,...

dec 12
13 views

SELECT TOP 10000 Title, Body, Tags, Id, Score, ViewCount,...

dec 12
14 views

SELECT TOP 10000 Title, Body, Tags, Id, Score, ViewCount,...

dec 12
8 views

SELECT AVG(AnswerCount * 1.0) AS AverageAnswers FROM Post...

dec 12 jon.doe46561
8 views

SELECT TOP 1 UserId, COUNT(*) AS CommentCount FROM Comments

dec 12 jon.doe46561
14 views

select top 1000 OwnerUserId from Posts group by OwnerUserId

dec 12
14 views

select top 100 OwnerUserId from Posts group by OwnerUserI...

dec 12
7 views

select top 100 count(*) from Posts group by OwnerUserId h...

dec 12
14 views

select top 100 count(*) from Posts group by OwnerUserId h...

dec 12
14 views

select top 100 count(*) from Posts group by OwnerUserId h...

dec 12
14 views

SELECT p.Id AS [Question Id], p.Title AS [Question Title]...

dec 12
12 views

Select * from Users WHERE Location like '%Germany%' OR Lo...

dec 12
7 views

Select * from Users WHERE Location like '%Germany%'

dec 12
12 views

Select * from Users WHERE Location like '%Germany%'

dec 12
7 views

SELECT p.Id AS [Question Id], p.Title AS [Question Title]...

dec 12
14 views

SELECT p.Id AS [Question Id], p.Title AS [Question Title]...

dec 12
65 views

Weekly run

dec 12 OnlineGeek
65 views

Weekly run

dec 12 OnlineGeek
19 views

Search in profiles

dec 12
16 views

SELECT p.Id AS [Post Link], p.Title, p.CreationDate, p.An...

dec 12 OnlineGeek
16 views

SELECT p.Id AS [Post Link], p.Title, p.CreationDate, p.An...

dec 12 OnlineGeek
14 views

SELECT p.Id AS [Post Link], p.Title, p.CreationDate, p.An...

dec 12
13 views

select t.Id, t.TagName, t.Count from Tags t where t.TagNa...

dec 12
14 views

select t.TagName, t.Count from Tags t where t.TagName IN ...

dec 12
14 views

select t.TagName, t.Count from Tags t where t.TagName = '...

dec 12
13 views

select t.Count from Tags t where t.TagName = 'javafx'

dec 12
7 views

select t.Count from Tags t where t.TagName = 'JavaFX'

dec 12
13 views

select t.Count from Tags t where t.TagName = 'JavaFX'

dec 12
14 views

select t.Count from Tags t where t.TagName = 'JavaFX'

dec 12
14 views

select t.Count from Tags t where t.TagName = 'JavaFX'

dec 12
13 views

select t.Count from Tags t where t.TagName = 'JavaFX'

dec 12
16 views

Search in user profiles

dec 12 VadimTagil
15 views

Search in profiles

dec 12
19 views

Search in profiles

dec 12
7 views

SELECT p.Id AS [Post Link], p.Title, p.CreationDate, p.An...

dec 12
14 views

SELECT p.Id AS [Post Link], p.Title, p.CreationDate, p.An...

dec 12
14 views

SELECT p.Title as QuestionTitle, p.Body as QuestionBody, ...

dec 12
14 views

SELECT Users.location as Location, Tags.TagName as Transp...

dec 12
13 views

SELECT Users.location as Location, Tags.TagName as Transp...

dec 12
13 views

SELECT TOP 20 p.Title as QuestionTitle, p.Body as Questio...

dec 12
14 views

SELECT 'https://travel.stackexchange.com/questions/' + CO...

dec 12
14 views

SELECT t.TagName as RailTopic, COUNT(DISTINCT p.Id) as To...

dec 12
13 views

SELECT t.TagName as RailTopic, COUNT(DISTINCT p.Id) as To...

dec 12
14 views

SELECT t.TagName as RailTopic, COUNT(DISTINCT p.Id) as To...

dec 12
14 views

SELECT t.TagName as Topic, COUNT(DISTINCT p.Id) as TotalQ...

dec 12
14 views

SELECT t.TagName as Topic, COUNT(DISTINCT p.Id) as TotalQ...

dec 12

30 50 100 per page