Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
0 views

SELECT TOP 10* FROM Posts WHERE CreationDate >= 2019;

oct 1
0 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
0 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
0 views

SELECT TOP 10* FROM Posts;

oct 1
0 views

SELECT TOP 420 /* Need to look at multiple tables unioned...

oct 1
0 views

SELECT PostTypeId, COUNT(*) as NrOfPosts FROM posts GROUP...

oct 1
0 views

SELECT PostTypeId, COUNT(*) as NrOfPosts FROM posts GROUP...

oct 1
0 views

SELECT TOP 400 /* Need to look at multiple tables unioned...

oct 1
5 views

SELECT TOP 10 * FROM Posts ORDER BY CreationDate;

oct 1
5 views

SELECT TOP 10 * FROM Posts;

oct 1
5 views

SELECT * FROM Posts;

oct 1
5 views

SELECT TOP 375 /* Need to look at multiple tables unioned...

oct 1
6 views

SELECT * FROM tags;

oct 1
6 views

SELECT * FROM tags;

oct 1
6 views

SELECT * FROM tags;

oct 1
5 views

SELECT * FROM tags;

oct 1
5 views

SELECT * FROM tags;

oct 1
5 views

SELECT * FROM tags;

oct 1
0 views

SELECT * FROM tags;

oct 1
0 views

SELECT * FROM tags;

oct 1
0 views

SELECT * FROM tags;

oct 1
0 views

SELECT * FROM tags;

oct 1
20 views

Votes per post over the years

oct 1 Polygnome
7 views

SELECT TOP 360 /* Need to look at multiple tables unioned...

oct 1
20 views

Votes per post over the years

oct 1 Polygnome
7 views

SELECT TOP 345 /* Need to look at multiple tables unioned...

oct 1
20 views

Votes per post over the years

oct 1 Polygnome
7 views

SELECT TOP 330 /* Need to look at multiple tables unioned...

oct 1
20 views

Votes per post over the years

oct 1 Polygnome
20 views

Votes per post over the years

oct 1 Polygnome
7 views

SELECT TOP 310 /* Need to look at multiple tables unioned...

oct 1
20 views

Votes per post over the years

oct 1 Polygnome
7 views

SELECT TOP 290 /* Need to look at multiple tables unioned...

oct 1
7 views

SELECT TOP 270 /* Need to look at multiple tables unioned...

oct 1
9 views

SELECT u.id FROM users AS u JOIN posts AS p ON u.id = p.o...

oct 1
9 views

SELECT u.id FROM users AS u JOIN posts AS p ON u.id = p.o...

oct 1
10 views

SELECT TOP 250 /* Need to look at multiple tables unioned...

oct 1
20 views

Votes per post over the years

oct 1 Polygnome
10 views

SELECT TOP 240 /* Need to look at multiple tables unioned...

oct 1
10 views

SELECT TOP 225 /* Need to look at multiple tables unioned...

oct 1
20 views

Votes per post over the years

oct 1 Polygnome
9 views

;WITH cte AS( SELECT Id, Title, PostTypeId, Score, RANK()...

oct 1
20 views

Votes per post over the years

oct 1 Polygnome
18 views

UserGrowthPost2014

oct 1
10 views

select (b.Post2014 - a.Pre2014)*100/a.Pre2014 as PostGrow...

oct 1
18 views

UserGrowthPost2014

oct 1
20 views

Votes per post over the years

oct 1 Polygnome
10 views

SELECT TOP 215 /* Need to look at multiple tables unioned...

oct 1
10 views

;WITH cte AS( SELECT Id, Title, PostTypeId, Score, RANK()...

oct 1
10 views

;WITH cte AS( SELECT Id, Title, PostTypeId, Score, RANK()...

oct 1
19 views

QuestionGrowthPrePost2014

oct 1
10 views

select (b.Post2014 - a.Pre2014)*100/a.Pre2014 as PostGrow...

oct 1
10 views

;WITH cte AS( SELECT Id, Title, PostTypeId, Score, RANK()...

oct 1
10 views

SELECT TOP 200 /* Need to look at multiple tables unioned...

oct 1
10 views

select (b.Post2014 - a.Pre2014)*100/a.Pre2014 as PostGrow...

oct 1
10 views

SELECT CAST(YEAR(p.CreationDate) AS VARCHAR(4)) + '-' + C...

oct 1
10 views

select (b.Post2014 - a.Pre2014)*100/a.Pre2014 as PostGrow...

oct 1
10 views

SELECT CAST(YEAR(p.CreationDate) AS VARCHAR(4)) + '-' + C...

oct 1
10 views

select (b.Post2014 - a.Pre2014)*100/a.Pre2014 as PostGrow...

oct 1
10 views

select (b.Post2014 - a.Pre2014)*100/a.Pre2014 as PostGrow...

oct 1
10 views

select (b.Post2014 - a.Pre2014)*100/a.Pre2014 as PostGrow...

oct 1
10 views

select (b.Post2014 - a.Pre2014)*100/a.Pre2014 as PostGrow...

oct 1
19 views

QuestionGrowthPrePost2014

oct 1
20 views

Votes per post over the years

oct 1 Polygnome
10 views

SELECT TOP 180 /* Need to look at multiple tables unioned...

oct 1
11 views

SELECT u.id, p.body, p.creationDate, CASE WHEN LEAD(p.cr...

oct 1
12 views

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

oct 1
12 views

SELECT TOP 170 /* Need to look at multiple tables unioned...

oct 1
12 views

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

oct 1
12 views

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

oct 1
12 views

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

oct 1
12 views

SELECT u.id, p.body, p.creationDate, LEAD(p.creationDate,...

oct 1
12 views

SELECT u.id, p.body, p.creationDate, LEAD(p.creationDate,...

oct 1
12 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
12 views

SELECT TOP 150 /* Need to look at multiple tables unioned...

oct 1
11 views

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

oct 1
11 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
11 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
11 views

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

oct 1
11 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
15 views

SELECT Year, FORMAT(SUM(OnCurrent),'0,,.00 M') as 'Votes ...

oct 1 Polygnome
11 views

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

oct 1
11 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
11 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
11 views

SELECT TOP 140 /* Need to look at multiple tables unioned...

oct 1
15 views

SELECT Year, FORMAT(SUM(OnCurrent),'0,,.00 M') as 'Votes ...

oct 1 Polygnome
11 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
15 views

SELECT Year, FORMAT(SUM(OnCurrent),'0,,.00 M') as VotesOn...

oct 1 Polygnome
11 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
10 views

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

oct 1
10 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
9 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
9 views

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

oct 1
9 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
9 views

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

oct 1
9 views

SELECT TOP 125 /* Need to look at multiple tables unioned...

oct 1
15 views

SELECT Year, SUM(OnCurrent) AS VotesOnCurrentPosts, SUM(O...

oct 1 Polygnome
7 views

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

oct 1
7 views

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

oct 1
8 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
8 views

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

oct 1
8 views

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

oct 1
15 views

SELECT Year, COUNT(OnCurrent) AS VotesOnCurrentPosts, COU...

oct 1 Polygnome
7 views

SELECT u.id, p.body, p.creationDate, CASE LEAD(p.creation...

oct 1
7 views

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

oct 1
15 views

SELECT Year, COUNT(OnCurrent) AS VotesOnCurrentPosts, COU...

oct 1 Polygnome
7 views

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

oct 1
8 views

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

oct 1
8 views

SELECT YEAR(Votes.CreationDate) AS YYear, OnCurrent = CAS...

oct 1 Polygnome
7 views

SELECT u.id, p.body, p.creationDate, DAY(LEAD(p.creationD...

oct 1
7 views

SELECT u.id, p.body, p.creationDate, LEAD(p.creationDate)...

oct 1
7 views

SELECT u.id, p.body, LEAD(p.creationDate) OVER (PARTITION...

oct 1
7 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
8 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
9 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
11 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
12 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
12 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
10 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
10 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
10 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
10 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
10 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
10 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
7 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
7 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
7 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
7 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
7 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
7 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
5 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
0 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1
0 views

SELECT TOP 100 /* Need to look at multiple tables unioned...

oct 1

30 50 100 per page