Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

12 views

SELECT * FROM ( SELECT YEAR(GETDATE()-1)*10000 + MONTH(GE...

apr 18
12 views

SELECT YEAR(GETDATE()-1)*10000 + MONTH(GETDATE()-1)*100 +...

apr 18
12 views

SELECT YEAR(GETDATE()-1)*10000 + MONTH(GETDATE()-1)*100 +...

apr 18
12 views

SELECT YEAR(GETDATE()-1)*10000 + MONTH(GETDATE()-1)*100 +...

apr 18
12 views

SELECT YEAR(GETDATE()-1)*10000 + MONTH(GETDATE()-1)*100 +...

apr 18
12 views

SELECT YEAR(GETDATE()-1)*10000 + MONTH(GETDATE()-1)*100 +...

apr 18
12 views

SELECT YEAR(GETDATE()-1)*10000 + MONTH(GETDATE()-1)*100 +...

apr 18
12 views

SELECT YEAR(GETDATE()-1)*10000 + MONTH(GETDATE()-1)*100 +...

apr 18
12 views

SELECT YEAR(GETDATE()-1)*10000 + MONTH(GETDATE()-1)*100 +...

apr 18
12 views

SELECT YEAR(GETDATE()-1)*10000 + MONTH(GETDATE()-1)*100 +...

apr 18
12 views

SELECT YEAR(GETDATE()-1)*10000 + MONTH(GETDATE()-1)*100 +...

apr 18
11 views

select distinct u.id as [User ID], u.displayname as [User...

apr 18
38 views

Users who've added a status tag to a post on Meta

apr 18 caird.coinheringaahing
50 views

select datediff(day,p."CreationDate",a."CreationDate") "D...

apr 18 Nemaja
10 views

SELECT Id, CreationDate, Score, ViewCount, Tags, AnswerCo...

apr 18
10 views

select body from posts where tags like '%pandas'

apr 18
50 views

select datediff(day,p."CreationDate",a."CreationDate") "D...

apr 18 Nemaja
11 views

SELECT Id, CreationDate, Score, ViewCount, Tags, AnswerCo...

apr 18
10 views

select * from tags;

apr 18
11 views

select * from tags;

apr 18
11 views

select * from tags;

apr 18
38 views

Users who've added a status tag to a post on Meta

apr 18 caird.coinheringaahing
38 views

Users who've added a status tag to a post on Meta

apr 18 caird.coinheringaahing
38 views

Users who've added a status tag to a post on Meta

apr 18 caird.coinheringaahing
38 views

Users who've added a status tag to a post on Meta

apr 18 caird.coinheringaahing
38 views

Users who've added a status tag to a post on Meta

apr 18 caird.coinheringaahing
12 views

SELECT COUNT( DISTINCT Id) From Users

apr 18
38 views

Users who've added a status tag to a post on Meta

apr 18 caird.coinheringaahing
38 views

Users who've added a status tag to a post on Meta

apr 18 caird.coinheringaahing
19 views

Users who've added a status tag to a post on Meta

apr 18 caird.coinheringaahing
53 views

Longest code review questions in Java

apr 18 Jonathan.Reez
53 views

Longest code review questions in Java

apr 18 Jonathan.Reez
53 views

Longest code review questions in Java

apr 18 Jonathan.Reez
22 views

Number of questions in Stack Overflow

apr 18
53 views

Longest code review questions in Java

apr 18 Jonathan.Reez
23 views

SQL query to fetch records based on related id in the same table

apr 18
23 views

SQL query to fetch records based on related id in the same table

apr 18
10 views

select FORMAT(p.CreationDate,'MMMM yyyy') 'Date', AVG(CAS...

apr 18
11 views

select FORMAT(p.CreationDate,'MMMM yyyy') 'Date', AVG(CAS...

apr 18
22 views

off2class

apr 18
12 views

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

apr 18
12 views

select FORMAT(p.CreationDate,'MMMM yyyy') 'Date', AVG(CAS...

apr 18
13 views

select FORMAT(p.CreationDate,'MMMM yyyy') 'Date', AVG(CAS...

apr 18
13 views

select FORMAT(p.CreationDate,'MMMM YYYY'), AVG(CAST(p.Vie...

apr 18
23 views

Boston test

apr 18
14 views

select MONTH(p.CreationDate), AVG(CAST(p.ViewCount AS BIG...

apr 18
10 views

select AVG(p.ViewCount), AVG((p.AnswerCount + p.CommentCo...

apr 18
11 views

select AVG(p.ViewCount), AVG((p.AnswerCount + p.CommentCo...

apr 18
12 views

select AVG(p.ViewCount), AVG((p.AnswerCount + p.CommentCo...

apr 18
13 views

select AVG(p.ViewCount), AVG((p.AnswerCount + p.CommentCo...

apr 18
13 views

select AVG(p.ViewCount), AVG((p.AnswerCount + p.CommentCo...

apr 18
14 views

select AVG(p.ViewCount), AVG((p.AnswerCount + p.CommentCo...

apr 18
14 views

select AVG(p.ViewCount), AVG((p.AnswerCount + p.CommentCo...

apr 18
14 views

select body from posts where parentid = 19960077

apr 18
10 views

select body from posts where parentid = 19960077

apr 18
10 views

select top(10) * from votes where votetypeid = 6

apr 18
11 views

select * from votes where votetypeid = 6

apr 18
10 views

select * from votetypes

apr 18
10 views

select * from closereasontypes

apr 18
10 views

select top(10) * from posts where closeddate is not null ...

apr 18
10 views

select top(10) * from posts where closeddate is null and ...

apr 18
10 views

select * from posttypes

apr 18
10 views

select top(10) * from posts where closeddate is null;

apr 18
10 views

select top(10) * from posts where closeddate is null;

apr 18
10 views

select top(10) * from posts where closeddate is null;

apr 18
10 views

select top(10) * from posts where closeddate is null;

apr 18
10 views

select top(10) * from posts where closeddate is null;

apr 18
10 views

select top(10) * from posts where closeddate is null;

apr 18
11 views

select top(10) * from posts where closeddate is null;

apr 18
10 views

select top(10) * from posts where closeddate is null;

apr 18
13 views

SELECT Body FROM Posts WHERE OwnerUserId = 290085 AND ...

apr 18 kjhughes36072
13 views

SELECT Body FROM Posts WHERE OwnerUserId = 290085 AND ...

apr 18 kjhughes36072
13 views

SELECT * FROM Posts WHERE OwnerUserId = 290085 AND ...

apr 18 kjhughes36072
13 views

SELECT * FROM Posts WHERE OwnerUserId = 290085 AND ...

apr 18 kjhughes36072
13 views

SELECT COUNT(*) FROM Posts WHERE OwnerUserId = 290085 ...

apr 18 kjhughes36072
1

22 views

Find questions ripe for the Revival and Necromancer badges

apr 18 Martin.Gergov
10 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

apr 18
10 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

apr 18
10 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

apr 18
10 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

apr 18
12 views

SELECT Count(*) AS CommentCount, Score FROM Comments WHER...

apr 18
11 views

select DISTINCT (qac.id) as id from ( select id as id ,t...

apr 18
14 views

SELECT clmns.colid as [Column_id], clmns.name AS [Column]...

apr 18 kindfamily
19 views

adfasdf

apr 18
19 views

adfasdf

apr 18
11 views

SELECT * FROM dbo.sysobjects AS tbl INNER JOIN sysusers ...

apr 18
11 views

SELECT * FROM dbo.sysobjects AS tbl INNER JOIN sysusers ...

apr 18
11 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

apr 18
14 views

SELECT * FROM dbo.sysobjects AS tbl INNER JOIN sysusers ...

apr 18 kindfamily
24 views

adfasdf

apr 18
19 views

adfasdf

apr 18
19 views

adfasdf

apr 18
13 views

select TOP 1 * from Posts where 1=0;

apr 18
12 views

SELECT TOP 100 * FROM Posts WHERE Score > 10

apr 18
13 views

select TOP 1 * from Posts;

apr 18
13 views

select TOP 1000 * from Posts;

apr 18
12 views

select TOP 1000 * from Posts;

apr 18
13 views

select TOP 1000 * from Posts where 1=1;

apr 18
12 views

SELECT TOP 100 * FROM Posts

apr 18
12 views

SELECT TOP 100 * FROM Posts

apr 18
14 views

select * from PostNotices;

apr 18 kindfamily
13 views

select * from PostNotices;

apr 18
12 views

select * from PostNotices

apr 18
11 views

select count(*) from ( select id as id ,title as title, ...

apr 18
12 views

select qac.id as id, qac.title as title, qac.body as body...

apr 18
11 views

select qac.id as id, qac.title as title, qac.body as body...

apr 18
11 views

select qac.id as id, qac.title as title, qac.body as body...

apr 18
16 views

select * from PostNotices;

apr 18
10 views

select * from PostTypes;

apr 18
17 views

select * from PostNotices;

apr 18
11 views

select TOP 100 PostId from PostNotices;

apr 18
12 views

select TOP 100 * from PostNotices;

apr 18
13 views

select * from PostNotices;

apr 18
13 views

select * from PostNotices;

apr 18
12 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

apr 18
19 views

Recently closed PHP questions by day

apr 18
11 views

select qac.id as id, qac.title as title, qac.body as body...

apr 18
13 views

SELECT TOP 100 Id, DisplayName, Reputation, WebsiteUrl, ...

apr 18
13 views

SELECT TOP 100 Id, DisplayName, Reputation, WebsiteUrl, ...

apr 18
13 views

SELECT TOP 100 Id, DisplayName, Reputation, WebsiteUrl, ...

apr 18
13 views

SELECT TOP 100 Id, DisplayName, Reputation, WebsiteUrl, ...

apr 18
13 views

SELECT TOP 100 Id, DisplayName, Reputation, WebsiteUrl, ...

apr 18
14 views

DECLARE @UserId int = ##UserId## create table #tags (Tag...

apr 18
14 views

DECLARE @UserId int = ##UserId## create table #tags (Tag...

apr 18
13 views

DECLARE @UserId int = ##UserId## create table #tags (Tag...

apr 18
13 views

select Id, DisplayName, ProfileImageUrl, EmailHash, Creat...

apr 18 nikitinippolit98
13 views

select Id, DisplayName, ProfileImageUrl, EmailHash, Creat...

apr 18 nikitinippolit98
14 views

DECLARE @UserId int = ##UserId## create table #tags (Ta...

apr 18
14 views

SELECT TOP 100 * from Posts

apr 18
13 views

DECLARE @UserId int = ##UserId## create table #tags (Ta...

apr 18
12 views

Select TOp 5 * FROM TagSynonyms

apr 18
12 views

Select TOp 5 * FROM PostLinks

apr 18

30 50 100 per page

1,700,068

queries

Q&A for people looking to improve their interpersonal communication skills

3.8k questions

14k answers

34k comments

277 tags

apr 18 most recent