Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

1 view

SELECT COUNT(*) FROM Users;

dec 11 jon.doe30899
1 view

SELECT p.Id AS QuestionId, p.Title AS QuestionTitle, p.Ta...

dec 11
2 views

SELECT p.Id AS QuestionId, p.Title AS QuestionTitle, p.Ta...

dec 11
4 views

SELECT p.Id AS QuestionId, p.Title AS QuestionTitle, p.Ta...

dec 11
5 views

SELECT p.Id AS QuestionId, p.Title AS QuestionTitle, p.Ta...

dec 11
5 views

SELECT p.Id AS QuestionId, p.Title AS QuestionTitle, p.Ta...

dec 11
5 views

SELECT p.Id AS QuestionId, p.Title AS QuestionTitle, p.Ta...

dec 11
86 views

SELECT OwnerUserID AS UserId, COUNT(*) AS AnswerCount FRO...

dec 11 jon.doe46557
86 views

SELECT OwnerUserID AS UserId, COUNT(*) AS PostCount FROM ...

dec 11 jon.doe46557
86 views

SELECT OwnerUserID AS UserId, COUNT(*) AS CommentCount FR...

dec 11 jon.doe46557
86 views

SELECT OwnerUserID, COUNT(*) AS CommentCount FROM Posts W...

dec 11 jon.doe46557
86 views

SELECT OwnerUserID, COUNT(*) AS PostCount FROM Posts GROU...

dec 11 jon.doe46557
86 views

SELECT Posts.OwnerUserID, AVG(Posts.Score) AS QualityScor...

dec 11 jon.doe46557
86 views

SELECT Posts.OwnerUserID, AVG(Posts.Score) AS QualityScor...

dec 11 jon.doe46557
86 views

SELECT Users.ID, Users.Reputation FROM Users JOIN Posts O...

dec 11 jon.doe46557
7 views

CREATE TABLE #tab1(X INT); CREATE TABLE #tab2(Y NVARCHAR...

dec 11
86 views

SELECT id FROM Posts WHERE PostTypeId =1 and AnswerCount ...

dec 11 jon.doe46557
7 views

SELECT TOP 20 TagName, COUNT(*) AS UpVotes FROM Tags INNE...

dec 11
86 views

SELECT Questions.ID AS QuestionID, AVG(Answers.Score) AS ...

dec 11 jon.doe46557
86 views

SELECT Questions.title AS QuestionTitle, AVG(Answers.Scor...

dec 11 jon.doe46557
86 views

SELECT Questions.ID AS QuestionID, AVG(Answers.Score) AS ...

dec 11 jon.doe46557
14 views

SELECT CURRENT_TIMESTAMP AS QueryRunTime, q.Id AS Questio...

dec 11
14 views

SELECT CURRENT_TIMESTAMP AS QueryRunTime, ROUND(AVG(Answe...

dec 11
14 views

SELECT CURRENT_TIMESTAMP AS QueryRunTime, ROUND(AVG(Answe...

dec 11
13 views

SELECT CURRENT_TIMESTAMP AS QueryRunTime, ROUND(AVG(Answe...

dec 11
7 views

SELECT TOP 100 p.Id AS [Post Link], p.Title, p.ViewCount ...

dec 11
7 views

SELECT TOP 100 p.Id AS [Post Link], p.Title, p.ViewCount ...

dec 11
14 views

SELECT CURRENT_TIMESTAMP AS QueryRunTime, UserId, COUNT(*...

dec 11
13 views

SELECT CURRENT_TIMESTAMP AS QueryRunTime, UserId, COUNT(*...

dec 11
86 views

select * from posttypes;

dec 11 jon.doe46557
7 views

DECLARE @startDate DATE = '2019-03-01'; DECLARE @endDate ...

dec 11
13 views

SELECT CURRENT_TIMESTAMP AS QueryRunTime, UserId, COUNT(*...

dec 11
7 views

select distinct Users.DisplayName, Users.Location, Use...

dec 11
14 views

SELECT CURRENT_TIMESTAMP AS QueryRunTime, UserId, COUNT(*...

dec 11
7 views

DECLARE @startDate DATE = '2019-03-01'; DECLARE @endDate ...

dec 11
14 views

SELECT CURRENT_TIMESTAMP AS QueryRunTime, Id AS QuestionId,

dec 11
7 views

SELECT TOP 100 p.Id AS [Post Link], p.Title, p.ViewCount ...

dec 11
14 views

SELECT COUNT(*) AS TotalQuestionComments, CURRENT_TIMESTA...

dec 11
14 views

SELECT COUNT(*) AS TotalComments FROM Comments c JOIN Pos...

dec 11
7 views

SELECT TOP 100 p.Id AS [Post Link], p.Title, p.ViewCount ...

dec 11
7 views

SELECT TOP 100 p.Id AS [Post Link], p.Title, p.ViewCount ...

dec 11
7 views

SELECT TOP 100 p.Id AS [Post Link], p.Title, p.ViewCount ...

dec 11
14 views

SELECT Id AS QuestionId, Title, (SELECT COUNT(*) FROM Com...

dec 11
14 views

select Id from Posts

dec 11
7 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select *from Posts

dec 11
7 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select count(Id) from users where reputation > 10000

dec 11
13 views

select count(Id) from users where reputation > 10000

dec 11
13 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select count(Id) from users where reputation > 10000

dec 11
13 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select count(Id) from users where reputation > 10000

dec 11
14 views

select count(Id) from users where reputation > 10000

dec 11
21 views

SELECT DISTINCT u.DisplayName FROM Users u WHERE u.Id IN ...

dec 11 jon.doe46558
7 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
21 views

SELECT u.DisplayName FROM Users u WHERE u.Location LIKE '...

dec 11 jon.doe46558
7 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
7 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
21 views

SELECT u.DisplayName FROM Users u WHERE (u.Location LIKE ...

dec 11 jon.doe46558
7 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
7 views

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

dec 11
7 views

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

dec 11
7 views

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

dec 11
86 views

SELECT Questions.ID AS QuestionID, AVG(Answers.Score) AS ...

dec 11 jon.doe46557
86 views

SELECT Title FROM Posts WHERE PostTypeId =1 and AnswerCou...

dec 11 jon.doe46557
6 views

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

dec 11
6 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
6 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
5 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
6 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
6 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
6 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
6 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
6 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
6 views

SELECT TOP 100 p.Id AS PostId, p.Title, p.Score AS PostSc...

dec 11
12 views

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

dec 11
7 views

SELECT TOP 100 p.Id as PostId, p.Title, p.Score as PostSc...

dec 11
6 views

SELECT TOP 100 p.Id as PostId, p.Title, p.Score as PostSc...

dec 11
12 views

SELECT count(Id) FROM Posts WHERE PostTypeId=1;

dec 11
11 views

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

dec 11
9 views

SELECT TOP 100 p.Id AS [Post Link], p.Title, p.ViewCount ...

dec 11
12 views

SELECT AnswerCount FROM Posts ORDER BY AnswerCount DESC;

dec 11
6 views

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

dec 11
12 views

SELECT AnswerCount FROM Posts;

dec 11
11 views

SELECT AVG(AnswerCount) FROM Posts;

dec 11
11 views

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

dec 11
12 views

SELECT count(Id) FROM Posts WHERE PostTypeId=1;

dec 11
11 views

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

dec 11
6 views

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

dec 11
11 views

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

dec 11
6 views

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

dec 11
6 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
11 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
11 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
12 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
11 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
11 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
12 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
12 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
11 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
12 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
12 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
11 views

SELECT COUNT(Id) as commentsCount, UserId FROM Comments G...

dec 11
13 views

SELECT SUM(CommentCount) FROM Posts WHERE PostTypeId =1;

dec 11
13 views

SELECT COUNT(*) FROM Comments JOIN Posts ON Comments.Post...

dec 11
14 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 11
14 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 11
14 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 11
14 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 11
14 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 11
6 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 11
14 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 11
14 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 11
14 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 11
14 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 11
14 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 11
13 views

SELECT COUNT(*) FROM Comments JOIN Posts ON Comments.Post...

dec 11
13 views

SELECT COUNT(*) FROM Comments JOIN Posts ON Comments.Post...

dec 11
11 views

SELECT SUM(CommentCount) FROM Posts WHERE PostTypeId =1;

dec 11
11 views

SELECT SUM(CommentCount) FROM Posts WHERE PostTypeId =1;

dec 11
14 views

SELECT SUM(CommentCount) FROM Posts;

dec 11

30 50 100 per page