Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
0 views

WITH AllTags AS ( SELECT CAST(YEAR(Posts.CreationDate) AS...

oct 18
0 views

WITH AllTags AS ( SELECT CAST(MONTH(Posts.CreationDate) A...

oct 18
1 view

WITH AllTags AS ( SELECT CAST(YEAR(Posts.CreationDate) AS...

oct 18
0 views

WITH AllTags AS ( SELECT Year(Posts.CreationDate) AS D, C...

oct 18
0 views

SELECT Id, 1 AS [Batch], ViewCount, Title FROM Posts OR...

oct 18
2 views

WITH AllTags AS ( SELECT CAST(YEAR(Posts.CreationDate) AS...

oct 18
1 view

WITH AllTags AS ( SELECT CAST(YEAR(Posts.CreationDate) AS...

oct 18
0 views

WITH AllTags AS ( SELECT CAST(YEAR(Posts.CreationDate) AS...

oct 18
1 view

SELECT Id, 1 AS [Batch], ViewCount, Title FROM Posts OR...

oct 18
1 view

WITH AllTags AS ( SELECT CAST(MONTH(Posts.CreationDate) A...

oct 18
2 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
2 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
3 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
3 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
3 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
3 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
3 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
2 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
2 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
1 view

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
0 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
0 views

IF( OBJECT_ID( 'tempdb.dbo.#tmpPopPostDD') IS NOT NULL ) ...

oct 18
6 views

DECLARE @UserId int = 184217 SELECT Id, PostId FROM Comm...

oct 18
6 views

DECLARE @UserId int = 184217 SELECT Id, PostId FROM Comm...

oct 18
7 views

select top 10 location from users where creationdate >='2...

oct 18
8 views

select top 10 * from users where creationdate >='2021-01-...

oct 18
9 views

SELECT * FROM tagsynonyms

oct 18
9 views

select top 10 * from users where creationdate >='2021-01-...

oct 18
9 views

select top 10 * from users where creationdate >='2021-09-...

oct 18
10 views

select top 10 * from users where creationdate >='2021-09-...

oct 18
10 views

select Id, PostTypeId, PostTypeId, ParentId, CreationDate...

oct 18
10 views

select top 10 * from users where creationdate >='2021-09-...

oct 18
9 views

select top 10 * from users where creationdate >='2021-09-...

oct 18
8 views

select top 10 * from users where creationdate >='2021-01-...

oct 18
8 views

select top 10 * from users where creationdate >='2021-01-...

oct 18
8 views

select top 10 * from users where creationdate >='2021-01-...

oct 18
8 views

select top 10 * from users where creationdate >='2021-01-...

oct 18
8 views

select top 10 * from users where creationdate >='2021-01-...

oct 18
8 views

select * from users where creationdate ='2021-01-01';

oct 18
8 views

select top 10 * from users where creationdate >='2021-02-...

oct 18
8 views

select count(*) from posts where posts.ViewCount = 200000...

oct 18
9 views

select count(*) from posts where posts.ViewCount>15000 an...

oct 18
8 views

select top 10 * from users where creationdate ='2021-02-01'

oct 18
8 views

select top 10 * from users where creationdate ='2021-02-0...

oct 18
8 views

select Id, PostTypeId, AcceptedAnswerId, ParentId, Creati...

oct 18
8 views

select top 10 * from users where creationdate ='2021-01-0...

oct 18
8 views

select top 10 * from users where creationdate >='2021-01-...

oct 18
10 views

select Id, PostTypeId, AcceptedAnswerId, ParentId, Creati...

oct 18
9 views

select * from VoteTypes;

oct 18
9 views

select * from ReviewTaskTypes;

oct 18
9 views

select * from ReviewTaskResultTypes;

oct 18
9 views

select * from PostTypes;

oct 18
9 views

select * from PostNoticeTypes;

oct 18
9 views

select * from PostHistoryTypes;

oct 18
9 views

select * from FlagTypes;

oct 18
9 views

select * from CloseReasonTypes;

oct 18
9 views

select * from CloseAsOffTopicReasonTypes; select * from C...

oct 18
15 views

Top Users by Location and Technology

oct 18
9 views

SELECT * FROM PostsWithDeleted WHERE ParentId=54087823;

oct 18
9 views

SELECT * FROM PostsWithDeleted WHERE ParentId=66700593;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=66700593;

oct 18
9 views

SELECT * FROM Posts WHERE Id=66700593;

oct 18
10 views

SELECT * FROM Posts WHERE Id=69622671;

oct 18
10 views

SELECT MAX(AnswerCount)--COUNT(DISTINCT Id) FROM Posts

oct 18
9 views

SELECT * FROM PostHistoryTypes; SELECT * FROM PostNoticeT...

oct 18
9 views

SELECT TOP 5 * --COUNT(DISTINCT Id) FROM Posts WHERE Crea...

oct 18
9 views

SELECT COUNT(DISTINCT Id) FROM Posts WHERE CreationDate >...

oct 18
10 views

SELECT * FROM PostHistoryTypes; SELECT * FROM PostNoticeT...

oct 18
10 views

SELECT * FROM PostHistoryTypes; SELECT * FROM PostNoticeT...

oct 18
10 views

SELECT * FROM PostNoticeTypes;

oct 18
10 views

SELECT * FROM Posts WHERE CreationDate >= '2012-01-01' AN...

oct 18
10 views

SELECT COUNT(DISTINCT PostTypeId) FROM Posts WHERE Creati...

oct 18
10 views

SELECT * --COUNT(DISTINCT PostTypeId) FROM Posts WHERE Cr...

oct 18
10 views

SELECT * FROM PostFeedback WHERE PostId=69622671; SELECT ...

oct 18
11 views

select * from users where id = 9545636

oct 18 yasir.Syed
12 views

SELECT * FROM PostNotices WHERE PostId=69622671;

oct 18
8 views

SELECT * FROM PostHistory WHERE PostId=69622671;

oct 18
8 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
12 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
10 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
10 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
10 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
8 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
10 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
9 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
10 views

SELECT * FROM PostFeedback WHERE PostId=69622671;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 1 * from users;

oct 18
8 views

select top 11 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
7 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
9 views

select top 10 * from users;

oct 18
10 views

select top 10 * from users;

oct 18
10 views

select top 10 * from users;

oct 18
9 views

select top 10 * from users;

oct 18
9 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
7 views

select top 10 * from users;

oct 18
5 views

select top 10 * from users;

oct 18
7 views

select top 10 * from users;

oct 18
8 views

select top 10 * from users;

oct 18
10 views

SELECT COUNT(DISTINCT PostTypeId) FROM Posts WHERE Creati...

oct 18
10 views

SELECT COUNT(DISTINCT PostTypeId) FROM Posts WHERE Creati...

oct 18
9 views

SELECT COUNT(DISTINCT PostTypeId) FROM Posts WHERE Creati...

oct 18
9 views

SELECT COUNT(DISTINCT PostTypeId) FROM Posts WHERE Creati...

oct 18
10 views

SELECT COUNT(DISTINCT PostTypeId) FROM Posts WHERE Creati...

oct 18
10 views

SELECT COUNT(DISTINCT PostTypeId) FROM Posts WHERE Creati...

oct 18
5 views

SELECT COUNT(DISTINCT PostTypeId) FROM Posts WHERE Creati...

oct 18
152 views

Comments for Top Questions and their Answers

oct 18 yasir.Syed
9 views

select count(*) from posts where posts.ViewCount>15000 an...

oct 18
8 views

select count(*) from posts where posts.ViewCount>15000 an...

oct 18
5 views

select count(*) from posts where posts.ViewCount>15000 an...

oct 18
152 views

Comments for Top Questions and their Answers

oct 18 yasir.Syed
152 views

Comments for Top Questions and their Answers

oct 18 yasir.Syed
152 views

Comments for Top Questions and their Answers

oct 18 yasir.Syed
152 views

Comments for Top Questions and their Answers

oct 18 yasir.Syed
15 views

View counts on answers by user by year

oct 18 Frank van Puffelen
15 views

View counts on answers by user by year

oct 18 Frank van Puffelen
15 views

View counts on answers by user by year

oct 18 Frank van Puffelen
15 views

View counts on answers by user by year

oct 18 Frank van Puffelen
15 views

View counts on answers by user by year

oct 18 Frank van Puffelen
15 views

View counts on answers by user by year

oct 18 Frank van Puffelen
15 views

View counts on answers by user by year

oct 18 Frank van Puffelen
15 views

View counts on answers by user by year

oct 18 Frank van Puffelen
15 views

View counts on answers by user by year

oct 18 Frank van Puffelen
56 views

select * from posts where YEAR(creationdate)=2013 and par...

oct 18 green.fuzer
5 views

select top 1 displayname, reputation from users inner joi...

oct 18
5 views

select top 1 displayname, reputation from users inner joi...

oct 18
15 views

View counts on answers by user by year

oct 18 Frank van Puffelen
5 views

select t.TagName, pExcerpt.Body from Tags t left join Pos...

oct 18
56 views

select * from posts where YEAR(creationdate)=2013 and par...

oct 18 green.fuzer
6 views

select t.TagName, pExcerpt.Body from Tags t left join Pos...

oct 18
15 views

View counts on answers by user by year

oct 18 Frank van Puffelen

30 50 100 per page