Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

WITH RankedUsers AS ( SELECT UserID, COUNT(*) AS CommentC...

dec 11 jon.doe46561
0 views

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

dec 11 jon.doe46561
1 view

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

dec 11 jon.doe46561
2 views

SELECT DisplayName FROM Users WHERE (Location LIKE 'Lug%'...

dec 11
4 views

SELECT DisplayName FROM Users WHERE Location LIKE '%Луган...

dec 11
8 views

DDL

dec 11
7 views

DDL

dec 11
8 views

DDL

dec 11
3 views

SELECT P.OwnerUserId AS UserId, COUNT(*) AS AnswerCount F...

dec 11
3 views

SELECT C.UserId, COUNT(*) AS CommentCount FROM Comments C...

dec 11
3 views

SELECT P.OwnerUserId AS UserId, COUNT(*) AS PostCount FRO...

dec 11
3 views

SELECT P.OwnerUserId AS UserId, AVG(P.Score) AS QualitySc...

dec 11
5 views

SELECT U.Id AS UserId, U.Reputation FROM Users U WHERE NO...

dec 11
3 views

SELECT U.Id AS UserId, U.Reputation FROM Users U WHERE NO...

dec 11
5 views

SELECT U.Id AS UserId, U.Reputation FROM Users U WHERE NO...

dec 11
89 views

SELECT Posts.OwnerUserId AS UserId, COUNT(*) AS AnswerCount

dec 11 jon.doe46559
5 views

SELECT ParentId AS QuestionId, AVG(Score) AS AverageScore...

dec 11
89 views

SELECT Comments.UserId AS UserId, COUNT(*) AS CommentCoun...

dec 11 jon.doe46559
7 views

SELECT ParentId AS QuestionId FROM Posts WHERE PostTypeId...

dec 11
89 views

SELECT Posts.OwnerUserId AS UserId, COUNT(*) AS PostCount...

dec 11 jon.doe46559
89 views

SELECT Posts.OwnerUserId AS UserId, AVG(Posts.Score) AS Q...

dec 11 jon.doe46559
6 views

SELECT Posts.Id AS QuestionId, AVG(Answers.Score) AS AvgA...

dec 11
89 views

SELECT Users.Id AS UserId, Users.Reputation FROM Users WH...

dec 11 jon.doe46559
89 views

SELECT Id AS UserId, Reputation FROM Users WHERE Id IN ( ...

dec 11 jon.doe46559
6 views

SELECT Users.Id, Users.Reputation FROM Users WHERE Users....

dec 11
6 views

SELECT Users.Id, Users.Reputation FROM Users WHERE Users....

dec 11
6 views

SELECT Users.Id, Users.Reputation FROM Users WHERE Users....

dec 11
6 views

SELECT Users.Id, Users.Reputation FROM Users WHERE Users....

dec 11
6 views

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE ...

dec 11
6 views

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

dec 11
6 views

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE ...

dec 11
3 views

SELECT Id AS QuestionId FROM Posts WHERE PostTypeId = 1 A...

dec 11
6 views

SELECT Id AS QuestionId FROM Posts WHERE PostTypeId = 1 A...

dec 11
6 views

SELECT Id AS QuestionId FROM Posts WHERE PostTypeId = 1 A...

dec 11
6 views

SELECT Id AS QuestionId FROM Posts WHERE PostTypeId = 1 A...

dec 11
6 views

SELECT Id AS QuestionId FROM Posts WHERE PostTypeId = 1 A...

dec 11
6 views

SELECT Id AS QuestionId FROM Posts WHERE PostTypeId = 1 A...

dec 11
6 views

SELECT Id AS QuestionId FROM Posts WHERE PostTypeId = 1 A...

dec 11
10 views

SELECT TOP 10 Posts.Id, Posts.Title FROM Posts LEFT JOIN ...

dec 11
9 views

SELECT TOP 10 Users.Id, Users.DisplayName FROM Users LEFT...

dec 11
89 views

SELECT Posts.ParentId AS QId, AVG(Posts.Score) AS AvgScor...

dec 11 jon.doe46559
10 views

SELECT Users.DisplayName, Posts.Title, Posts.Body FROM Po...

dec 11
89 views

SELECT Id as Qid FROM Posts WHERE PostTypeId = 1 AND Answ...

dec 11 jon.doe46559
89 views

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

dec 11 jon.doe46559
89 views

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

dec 11 jon.doe46559
14 views

SELECT TOP 10 Posts.Id, Posts.Title FROM Posts LEFT JOIN ...

dec 11
7 views

SELECT TOP 10 Users.Id, Users.DisplayName FROM Users LEFT...

dec 11
14 views

SELECT TOP 10 Users.Id, Users.DisplayName FROM Users LEFT...

dec 11
10 views

SELECT TOP 10 Users.Id, Users.DisplayName FROM Users LEFT...

dec 11
9 views

SELECT TOP 10 Users.Id, Users.DisplayName FROM Users LEFT...

dec 11
10 views

SELECT TOP 10 Users.Id, Users.DisplayName FROM Users LEFT...

dec 11
6 views

SELECT TOP 10 Users.Id, Users.DisplayName FROM Users LEFT...

dec 11
6 views

SELECT TOP 10 Users.Id, Users.DisplayName FROM Users LEFT...

dec 11
4 views

SELECT TOP 10 Users.Id, Users.DisplayName FROM Users LEFT...

dec 11
2 views

SELECT TOP 10 Users.Id, Users.DisplayName FROM Users LEFT...

dec 11
89 views

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

dec 11 jon.doe46559
89 views

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

dec 11 jon.doe46559
89 views

SELECT UserId FROM Comments GROUP BY UserId HAVING COUNT(...

dec 11 jon.doe46559
14 views

SELECT COUNT(*) FROM Users U WHERE U.Reputation >= 3000; ...

dec 11
7 views

SELECT COUNT(*) FROM Users U WHERE U.Reputation >= 3000; ...

dec 11
14 views

SELECT COUNT(*) FROM Users U WHERE U.Reputation >= 3000; ...

dec 11
89 views

SELECT UserId FROM Comments GROUP BY UserId HAVING COUNT(...

dec 11 jon.doe46559
14 views

SELECT ParentId AS QuestionId, AVG(Score) AS AverageScore...

dec 11
21 views

comments

dec 11
15 views

SELECT ParentId AS QuestionId FROM Posts WHERE PostTypeId...

dec 11
15 views

comments

dec 11
21 views

comments

dec 11
89 views

SELECT UserId FROM Comments GROUP BY UserId HAVING COUNT(...

dec 11 jon.doe46559
7 views

SELECT ParentId AS QuestionId FROM Posts WHERE PostTypeId...

dec 11
15 views

SELECT ParentId AS QuestionId FROM Posts WHERE PostTypeId...

dec 11
14 views

SELECT ParentId AS QuestionId FROM Posts WHERE PostTypeId...

dec 11
7 views

SELECT ParentId AS QuestionId FROM Posts WHERE PostTypeId...

dec 11
5 views

SELECT ParentId AS QuestionId FROM Posts WHERE PostTypeId...

dec 11
7 views

SELECT COUNT(*) AS CommentCount FROM Comments JOIN Posts ...

dec 11
7 views

SELECT ParentId AS QuestionId FROM Posts WHERE PostTypeId...

dec 11
89 views

SELECT UserId FROM Comments GROUP BY UserId HAVING COUNT(...

dec 11 jon.doe46559
89 views

SELECT UserId FROM Comments GROUP BY UserId HAVING COUNT(...

dec 11 jon.doe46559
89 views

SELECT UserId FROM Comments GROUP BY UserId HAVING COUNT(...

dec 11 jon.doe46559
7 views

SELECT ParentId AS QuestionId FROM Posts WHERE PostTypeId...

dec 11
6 views

select OwnerUserID, count(*) from ( select Posts.Id PostI...

dec 11 Jonathan Gennick
6 views

SELECT ParentId AS QuestionId FROM Posts WHERE PostTypeId...

dec 11
11 views

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

dec 11
11 views

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

dec 11
6 views

SELECT TOP (150) ROW_NUMBER() OVER(ORDER BY Reputation DE...

dec 11
6 views

SELECT TOP (150) ROW_NUMBER() OVER(ORDER BY Reputation DE...

dec 11
6 views

SELECT TOP (150) ROW_NUMBER() OVER(ORDER BY Reputation DE...

dec 11
6 views

SELECT TOP (150) ROW_NUMBER() OVER(ORDER BY Reputation DE...

dec 11
5 views

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

dec 11
11 views

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

dec 11
11 views

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

dec 11
5 views

SELECT TOP (150) ROW_NUMBER() OVER(ORDER BY Reputation DE...

dec 11
5 views

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

dec 11
5 views

SELECT TOP (150) ROW_NUMBER() OVER(ORDER BY Reputation DE...

dec 11
5 views

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

dec 11
10 views

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

dec 11
5 views

SELECT TOP (150) ROW_NUMBER() OVER(ORDER BY Reputation DE...

dec 11
7 views

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

dec 11
10 views

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

dec 11
9 views

SELECT ROW_NUMBER() OVER (ORDER BY tuser.Tag_Score DESC)...

dec 11
10 views

SELECT ROW_NUMBER() OVER (ORDER BY tuser.Tag_Score DESC)...

dec 11
5 views

SELECT ROW_NUMBER() OVER (ORDER BY tuser.Tag_Score DESC)...

dec 11
10 views

SELECT ROW_NUMBER() OVER (ORDER BY tuser.Tag_Score DESC)...

dec 11
9 views

SELECT ROW_NUMBER() OVER (ORDER BY tuser.Tag_Score DESC)...

dec 11
10 views

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

dec 11
10 views

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

dec 11
10 views

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

dec 11
5 views

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

dec 11
10 views

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

dec 11
10 views

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

dec 11
10 views

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

dec 11
3 views

SELECT count(ID) from users where reputation>10000

dec 11
3 views

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

dec 11
10 views

Vacation

dec 11
11 views

Vacation

dec 11
11 views

Vacation

dec 11
10 views

Vacation

dec 11
11 views

Vacation

dec 11
11 views

Vacation

dec 11
11 views

Vacation

dec 11
10 views

Vacation

dec 11
10 views

Vacation

dec 11
3 views

SELECT ParentId AS QuestionId FROM Posts WHERE PostTypeId...

dec 11
11 views

Vacation

dec 11
10 views

Vacation

dec 11
11 views

Vacation

dec 11
11 views

Vacation

dec 11
11 views

Vacation

dec 11
11 views

Vacation

dec 11
11 views

Vacation

dec 11
3 views

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

dec 11

30 50 100 per page

2,279,119

queries

Q&A for professionals, academics, and students working within the systems development life cycle

64k questions

180k answers

551k comments

1.7k tags

dec 7 most recent