Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

1 view

Old Potential Non-Answers (OPNA)

dec 11
4 views

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

dec 11
6 views

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

dec 11
5 views

SELECT COUNT(*) FROM Comments WHERE PostID IN (SELECT Pos...

dec 11
5 views

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

dec 11
5 views

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

dec 11
6 views

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

dec 11
4 views

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

dec 11
5 views

select TOP 3 * from Users;

dec 11
5 views

declare @table table (Email varchar(64), Phone varchar(16...

dec 11
5 views

select * from Users;

dec 11
16 views

SELECT Posts.OwnerUserId AS [User ID], COUNT(Posts.Id) AS...

dec 11
16 views

SELECT Posts.OwnerUserId AS [User ID], AVG(Posts.Score) A...

dec 11
17 views

SELECT Users.Id AS [User ID], Users.Reputation AS [Reputa...

dec 11
15 views

SELECT Users.Id AS [شناسه کاربر / User ID], Users.Reputat...

dec 11
17 views

SELECT Users.Id AS [User ID], Users.Reputation AS [Reputa...

dec 11
20 views

SELECT Posts.Id AS [شناسه سوال], AVG(Answers.Score) AS [م...

dec 11
19 views

SELECT AVG(AnswerCount) AS [Average Answer Count] FROM Po...

dec 11
18 views

SELECT UserId AS [User ID], COUNT(*) AS [Comment Count] F...

dec 11
18 views

SELECT SUM(Posts.CommentCount) AS [Total Comment Count] F...

dec 11
9 views

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

dec 11
20 views

SELECT Posts.Id AS QId FROM Posts WHERE Posts.PostTypeId ...

dec 11
79 views

SELECT COUNT(*) FROM Comments WHERE PostId IN ( SELECT Id...

dec 11 jon.doe46559
18 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
9 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
18 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
20 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
18 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
18 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
19 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
20 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
17 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
15 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
17 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
16 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
16 views

SELECT TOP 1 UserId, COUNT(*) AS TotalComments FROM Comme...

dec 11
79 views

select count(Id) from users where reputation>1120000

dec 11 jon.doe46559
79 views

select count(Id) from users where reputation>1080000

dec 11 jon.doe46559
79 views

select count(Id) from users where reputation>1000000

dec 11 jon.doe46559
79 views

select count(Id) from users where reputation>2000000

dec 11 jon.doe46559
79 views

select count(Id) from users where reputation>10000000

dec 11 jon.doe46559
79 views

select count(Id) from users where reputation>1000000

dec 11 jon.doe46559
79 views

select count(Id) from users where reputation>10000

dec 11 jon.doe46559
79 views

select count(Id) from users where reputation>10000

dec 11 jon.doe46559
20 views

select UserId from Comments

dec 11
8 views

SELECT * From Posts WHERE CreationDate >= '2015-03-17' AN...

dec 11
18 views

select Avg(AnswerCount) from Posts

dec 11
20 views

select Sum(AnswerCount) from Posts

dec 11
10 views

SELECT * From Posts WHERE CreationDate >= '2003-03-17' AN...

dec 11
19 views

select AnswerCount from Posts

dec 11
17 views

select Avg(AnswerCount) from Posts

dec 11
19 views

select count(Id) from users where reputation>10000

dec 11
9 views

select count(Id) from users where reputation>10000

dec 11
19 views

select count(Id) from users where reputation>10000

dec 11
18 views

select UserId from Comments

dec 11
19 views

select count(CommentCount) from Posts

dec 11
10 views

select CommentCount from Posts

dec 11
19 views

select CommentCount from Posts

dec 11
18 views

select CommentCount from Posts

dec 11
17 views

select CommentCount from Posts

dec 11
19 views

select CommentCount from Posts

dec 11
20 views

select CommentCount from Posts

dec 11
18 views

select CommentCount from Posts

dec 11
20 views

select CommentCount from Posts

dec 11
52 views

SELECT TOP 200 * FROM Users WHERE Reputation < 100 ORDER ...

dec 11 Pet237d160.The160.Spring160.Wizard
52 views

SELECT TOP 200 * FROM Users ORDER BY Views DESC;

dec 11 Pet237d160.The160.Spring160.Wizard
52 views

SELECT TOP 200 * FROM Users WHERE Reputation = 1 ORDER BY...

dec 11 Pet237d160.The160.Spring160.Wizard
18 views

select * from Posts where Id = 37714

dec 11
20 views

select * from Posts where Id = 44854

dec 11
8 views

select * from posts where id = 44854

dec 11
20 views

select * from posts where id = 44854

dec 11
18 views

select * from posts where id = 44854

dec 11
52 views

SELECT TOP 200 * FROM Users WHERE Reputation = 1 ORDER BY...

dec 11 Pet237d160.The160.Spring160.Wizard
52 views

SELECT TOP 200 * FROM Users WHERE Reputation = 1 ORDER BY...

dec 11 Pet237d160.The160.Spring160.Wizard
52 views

SELECT TOP 200 * FROM Users WHERE Reputation = 1 ORDER BY...

dec 11 Pet237d160.The160.Spring160.Wizard
11 views

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

dec 11
15 views

Tags and their synonyms

dec 11
18 views

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

dec 11
16 views

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

dec 11
16 views

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

dec 11
17 views

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

dec 11
16 views

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

dec 11
15 views

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

dec 11
15 views

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

dec 11
15 views

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

dec 11
16 views

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

dec 11
8 views

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

dec 11
16 views

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

dec 11
15 views

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

dec 11
15 views

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

dec 11
15 views

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

dec 11
16 views

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

dec 11
17 views

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

dec 11
16 views

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

dec 11
16 views

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

dec 11
18 views

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

dec 11
15 views

Most popular StackOverflow tags in May 2010

dec 11
13 views

Most popular StackOverflow tags in May 2010

dec 11
8 views

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

dec 11
24 views

SELECT COUNT(*) FROM Users;

dec 11 jon.doe30899
24 views

SELECT COUNT(DISTINCT OwnerUserId) FROM Posts;

dec 11 jon.doe30899
24 views

SELECT COUNT(*) FROM Users;

dec 11 jon.doe30899
8 views

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

dec 11
8 views

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

dec 11
8 views

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

dec 11
8 views

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

dec 11
8 views

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

dec 11
7 views

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

dec 11
102 views

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

dec 11 jon.doe46557
102 views

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

dec 11 jon.doe46557
102 views

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

dec 11 jon.doe46557
102 views

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

dec 11 jon.doe46557
102 views

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

dec 11 jon.doe46557
102 views

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

dec 11 jon.doe46557
102 views

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

dec 11 jon.doe46557
102 views

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

dec 11 jon.doe46557
8 views

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

dec 11
102 views

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

dec 11 jon.doe46557
8 views

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

dec 11
102 views

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

dec 11 jon.doe46557
102 views

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

dec 11 jon.doe46557
102 views

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

dec 11 jon.doe46557
15 views

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

dec 11
15 views

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

dec 11
15 views

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

dec 11
15 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
8 views

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

dec 11
15 views

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

dec 11
14 views

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

dec 11
102 views

select * from posttypes;

dec 11 jon.doe46557
7 views

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

dec 11
14 views

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

dec 11

30 50 100 per page

2,278,989

queries

Q&A about the site for administrators and users of the CiviCRM Constituent Relationship Management software

72 questions

113 answers

121 comments

70 tags

jan 24 most recent