Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

SELECT YEAR(CreationDate) AS CreationYear, COUNT(*) AS Us...

dec 7
0 views

SELECT u.ID, CONVERT(DATE, u.CreationDate) AS UserCreateD...

dec 7
4 views

SELECT u.ID, CONVERT(DATE, u.CreationDate) AS UserCreateD...

dec 7
2 views

SELECT u.ID, CONVERT(DATE, u.CreationDate) AS UserCreateD...

dec 7
4 views

SELECT u.ID, CONVERT(DATE, u.CreationDate) AS UserCreateD...

dec 7
4 views

SELECT YEAR(CreationDate) AS CreationYear, COUNT(*) AS Us...

dec 7
2 views

SELECT TOP 10 * FROM Users ORDER BY CreationDate DESC;

dec 7
2 views

SELECT COUNT(*) AS TotalUsers FROM Users;

dec 7
4 views

SELECT COUNT(*) AS TotalUsers FROM Users;

dec 7
6 views

select * from VoteTypes

dec 7
7 views

SELECT q.Id AS question_id, -- Question ID q.Titl...

dec 6
14 views

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

dec 6
14 views

SELECT Tags.TagName as TransportType, COUNT(DISTINCT Post...

dec 6
14 views

SELECT Tags.TagName as TransportType, COUNT(DISTINCT Post...

dec 6
14 views

SELECT Tags.TagName as TransportType, COUNT(DISTINCT Post...

dec 6
14 views

SELECT Tags.TagName as TransportType, COUNT(DISTINCT Post...

dec 6
14 views

SELECT DATEPART(MONTH, Posts.CreationDate) as Month, COUN...

dec 6
14 views

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

dec 6
13 views

SELECT Tags.TagName as Platform, COUNT(DISTINCT Posts.Id)...

dec 6
14 views

SELECT Users.Location, Tags.TagName, COUNT(*) as PostCount,

dec 6
14 views

SELECT Users.Location, Tags.TagName, COUNT(*) as PostCount,

dec 6
13 views

SELECT Tags.TagName, COUNT(*) as PostCount, AVG(CAST(Post...

dec 6
14 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
14 views

SELECT Tags.TagName, COUNT(*) as PostCount, AVG(CAST(Post...

dec 6
14 views

SELECT DATEPART(YEAR, Posts.CreationDate) as Year, DATEPA...

dec 6
14 views

SELECT DATEADD(month, DATEDIFF(month, 0, Posts.CreationDa...

dec 6
13 views

SELECT DATEADD(month, DATEDIFF(month, 0, Posts.CreationDa...

dec 6
14 views

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

dec 6
13 views

SELECT Tags.TagName as Region, COUNT(DISTINCT Posts.Id) a...

dec 6
14 views

SELECT TOP 100 Posts.Title, Posts.ViewCount, Posts.Score,...

dec 6
14 views

SELECT Tags.TagName as Region, COUNT(DISTINCT Posts.Id) a...

dec 6
14 views

SELECT Tags.TagName, COUNT(*) as PostCount, AVG(CAST(Post...

dec 6
7 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
13 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
13 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
13 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
13 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
8 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
14 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
7 views

SELECT TagName, Count FROM Tags WHERE TagName IN ('india'...

dec 6
7 views

SELECT TagName, Count FROM Tags WHERE TagName IN ('india'...

dec 6
7 views

SELECT TOP 100 'https://travel.stackexchange.com/question...

dec 6
7 views

SELECT TOP 100 'https://stackoverflow.com/questions/' + C...

dec 6
12 views

SELECT Location, COUNT(*) AS QuestionCount FROM Users WHE...

dec 6 jon.doe46507
7 views

SELECT TOP 100 'https://stackoverflow.com/questions/' + C...

dec 6
7 views

SELECT TOP 100 'https://stackoverflow.com/questions/' + C...

dec 6
7 views

SELECT TagName, Count FROM Tags WHERE TagName LIKE '%book%'

dec 6
7 views

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

dec 6
12 views

SELECT Tags.TagName as Region, COUNT(DISTINCT Posts.Id) a...

dec 6
16 views

SELECT TOP 100 Posts.Title, Posts.ViewCount, Posts.Score,...

dec 6
14 views

SELECT Tags.TagName, COUNT(DISTINCT Posts.Id) as Question...

dec 6
11 views

SELECT DATEADD(month, DATEDIFF(month, 0, Posts.CreationDa...

dec 6
12 views

SELECT Tags.TagName as Region, COUNT(DISTINCT Posts.Id) a...

dec 6
12 views

SELECT Tags.TagName as Region, COUNT(DISTINCT Posts.Id) a...

dec 6
12 views

SELECT Tags.TagName, COUNT(*) as PostCount, AVG(CAST(Post...

dec 6
12 views

SELECT TOP 50 TagName, COUNT(PostTags.PostId) AS UsageCount

dec 6
12 views

SELECT TOP 1 'https://travel.stackexchange.com/questions/...

dec 6
12 views

SELECT TOP 1 'https://travel.stackexchange.com/questions/...

dec 6
12 views

SELECT TOP 1 'https://travel.stackexchange.com/questions/...

dec 6
12 views

SELECT TOP 1 'https://travel.stackexchange.com/questions/...

dec 6
12 views

SELECT TagName, COUNT(*) AS TagCount FROM Tags JOIN PostT...

dec 6
12 views

SELECT TOP 10 TagName, COUNT(*) AS TagCount FROM Tags JOI...

dec 6
12 views

SELECT TOP 10 TagName, COUNT(*) AS TagCount FROM Tags JOI...

dec 6
12 views

SELECT TOP 10 TagName, COUNT(*) AS TagCount FROM Tags JOI...

dec 6
11 views

SELECT TOP 10 TagName, COUNT(*) AS TagCount FROM Tags JOI...

dec 6
11 views

SELECT TOP 10 Location, COUNT(*) AS QuestionCount FROM Us...

dec 6
11 views

SELECT TOP 10 Location, COUNT(*) AS QuestionCount FROM Us...

dec 6
11 views

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

dec 6
11 views

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

dec 6
11 views

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

dec 6
11 views

SELECT TOP 10 TagName, COUNT(*) AS TagCount FROM Tags JOI...

dec 6
11 views

SELECT TOP 10 TagName, COUNT(*) AS TagCount FROM Tags JOI...

dec 6
13 views

SELECT TagName, Count FROM Tags ORDER BY Count DESC;

dec 6
12 views

SELECT TagName FROM Tags WHERE TagName LIKE '%travel%';

dec 6
12 views

SELECT TagName FROM Tags WHERE TagName LIKE '%expedia%';

dec 6
12 views

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

dec 6
12 views

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

dec 6
12 views

SELECT Tags.TagName, COUNT(PostTags.PostId) AS UsageCount...

dec 6
12 views

SELECT Tags.TagName, COUNT(PostTags.PostId) AS UsageCount...

dec 6
6 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
13 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
11 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
11 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
11 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
11 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
11 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
11 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
11 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
11 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
11 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
14 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
16 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
12 views

SELECT Users.Location, COUNT(*) AS QuestionCount FROM Users

dec 6
7 views

select * from Tags where Tagname like '%netbeans%'

dec 6
15 views

SELECT 'https://stackoverflow.com/questions/' + CONVERT(V...

dec 6
8 views

SELECT Location, COUNT(*) AS QuestionCount FROM Users WHE...

dec 6
15 views

SELECT Location, COUNT(*) AS QuestionCount FROM Users WHE...

dec 6
12 views

SELECT Location, COUNT(*) AS QuestionCount FROM Users WHE...

dec 6
28 views

Ids

dec 6
82 views

NAADetector

dec 6 Starship
82 views

NAADetector

dec 6 Starship
82 views

NAADetector

dec 6 Starship
38 views

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

dec 6 jon.doe46505
21 views

Ids

dec 6
38 views

SELECT P.Id AS QuestionId, AVG(A.Score) AS AvgAnswerScore...

dec 6 jon.doe46505
14 views

Ids

dec 6
21 views

Ids

dec 6
28 views

Ids

dec 6
38 views

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

dec 6 jon.doe46505
82 views

NAADetector

dec 6 Starship
82 views

NAADetector

dec 6 Starship
14 views

Most duplicated Python questions

dec 6
38 views

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

dec 6 jon.doe46505
14 views

select * from users where displayName like 'Rohan%'

dec 6
15 views

select * from users where displayName like 'rohan%'

dec 6
14 views

select top 100 * from posts;

dec 6
14 views

SELECT * FROM TAGS WHERE TAGNAME = 'Java';

dec 6
38 views

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

dec 6 jon.doe46505
6 views

SELECT * FROM TAGS;

dec 6
14 views

SELECT * FROM TAGS;

dec 6
14 views

SELECT * FROM TAGS;

dec 6
15 views

SELECT * FROM TAGS;

dec 6
14 views

SELECT * FROM TAGS;

dec 6
38 views

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

dec 6 jon.doe46505
22 views

Posts by Type

dec 6
14 views

SELECT Posts.PostTypeId as PostTypeId, min(PostTypes.Name...

dec 6
14 views

SELECT Posts.PostTypeId as PostTypeId, min(PostTypes.Name...

dec 6

30 50 100 per page

2,277,982

queries

Q&A for developers and researchers interested in open data

6.2k questions

7.3k answers

12k comments

312 tags

nov 28 most recent