Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

select Month(CreationDate), count(*) from Users group by ...

jan 21
0 views

select Month(CreationDate), count(*) from Users group by ...

jan 21
0 views

select CreationDate, count(*) from Users group by Creatio...

jan 21
2 views

select * from Posts

jan 21
7 views

CREATE TABLE #yt ([Store] int, [Week] int, [xCount] int) ;

jan 21
70 views

select top 100 p.Id as [Post Link],p.body, c.Id as [Com...

jan 21 Musenga
11 views

Test

jan 21
12 views

Test

jan 21
13 views

Test

jan 21
70 views

select top 10 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
19 views

unpivot (or cross apply) multiple columns

jan 21
70 views

select top 100 p.Id as [Post Link],p.body, c.Id as [Com...

jan 21 Musenga
20 views

unpivot (or cross apply) multiple columns

jan 21
12 views

select distinct Users.DisplayName, Users.Location, Us...

jan 21
12 views

select distinct Users.DisplayName, Users.Location, Us...

jan 21
12 views

select distinct Users.DisplayName, Users.Location, Us...

jan 21
70 views

select top 20 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
70 views

select top 10 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
70 views

select top 10 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
70 views

select top 10 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
70 views

select top 20 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
13 views

select distinct Users.DisplayName, Users.Location, Us...

jan 21
13 views

select distinct Users.DisplayName, Users.Location, Us...

jan 21
70 views

select top 20 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
13 views

select distinct Users.DisplayName, Users.Location, Us...

jan 21
13 views

select distinct Users.DisplayName, Users.Location, Us...

jan 21
13 views

select distinct Users.DisplayName, Users.Location, Us...

jan 21
70 views

select top 30 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
15 views

select top 1 * from posts where body not like '<p>%'

jan 21 jon.doe32957
70 views

select top 30 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
40 views

SELECT count(p.id) FROM posts p, posthistory ph WHERE p.p...

jan 21 Balazs Nagy
40 views

SELECT count(p.id) FROM posts p, posthistory ph WHERE p.p...

jan 21 Balazs Nagy
13 views

CREATE TABLE #yt ([Store] int, [Week] int, [xCount] int) ;

jan 21
40 views

SELECT count(p.id) FROM posts p, posthistory ph WHERE p.p...

jan 21 Balazs Nagy
70 views

select top 30 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
70 views

select top 20 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
70 views

select top 20 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
70 views

select top 20 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
70 views

select top 20 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
70 views

select top 10 p.Id as [Post Link],p.body, c.Id as [Comm...

jan 21 Musenga
24 views

IronPython Questions

jan 21
27 views

HW1

jan 21
28 views

HW1

jan 21
15 views

select top 200 Id as [Post Link], Score, ViewCount from P...

jan 21 Musenga
29 views

HW1

jan 21
18 views

select count(id) from Users where location LIKE '%Deutsch...

jan 21
17 views

select count(id) from Users where location LIKE '%Germany...

jan 21
29 views

HW1

jan 21
17 views

select count(id) from Users where location LIKE '%India%';

jan 21
15 views

select top 200 Id as [Post Link], Score, ViewCount from P...

jan 21 Musenga
17 views

select id, location from Users where location is not null;

jan 21
16 views

select id, location from Users;

jan 21
17 views

select id, location from Users;

jan 21
17 views

select id, location from Users;

jan 21
17 views

select id, location from Users;

jan 21
18 views

select id, location from Users;

jan 21
23 views

select top 200 Id as [Post Link], Score, ViewCount from P...

jan 21 Musenga
23 views

select top 200 Id as [Post Link], Score, ViewCount from P...

jan 21 Musenga
23 views

select top 200 Id as [Post Link], Score, ViewCount from P...

jan 21 Musenga
30 views

HW1

jan 21
23 views

select top 200 Id as [Post Link], Score, ViewCount as "Vi...

jan 21 Musenga
23 views

select top 200 Id as [Post Link], Score, ViewCount from P...

jan 21 Musenga
23 views

select top 200 Id as [Post Link], Score, ViewCount from P...

jan 21 Musenga
33 views

HW1

jan 21
31 views

HW1

jan 21
12 views

DECLARE @StartTime DATE = convert(DATE, '##StartTime?2000...

jan 21
11 views

DECLARE @StartTime DATE = convert(DATE, '##StartTime?2000...

jan 21
11 views

DECLARE @StartTime DATE = convert(DATE, '##StartTime?2000...

jan 21
11 views

DECLARE @StartTime DATE = convert(DATE, '##StartTime?2000...

jan 21
29 views

HW1

jan 21
31 views

HW1

jan 21
33 views

HW1

jan 21
30 views

HW1

jan 21
29 views

HW1

jan 21
29 views

HW1

jan 21
28 views

HW1

jan 21
27 views

HW1

jan 21
13 views

select Id as [Post Link],Title, Score, ViewCount from Posts

jan 21 Musenga
102 views

Select * from Badges

jan 21 jon.doe33023
11 views

DECLARE @StartTime DATE = convert(DATE, '##StartTime?2000...

jan 21
23 views

Top Romanian users all

jan 21
11 views

DECLARE @StartTime DATE = convert(DATE, '##StartTime?2000...

jan 21
11 views

DECLARE @StartTime DATE = convert(DATE, '##StartTime?2000...

jan 21
11 views

DECLARE @StartTime DATE = convert(DATE, '##StartTime?2000...

jan 21
11 views

DECLARE @StartTime DATE = convert(DATE, '##StartTime?2000...

jan 21
11 views

DECLARE @StartTime DATE = convert(DATE, '##StartTime?2000...

jan 21
12 views

DECLARE @StartTime DATE = convert(DATE, '##StartTime?2000...

jan 21
33 views

Playground

jan 21 Trilarion
13 views

select Id as [Post Link], Score, ViewCount from Posts whe...

jan 21 Musenga
23 views

C# about partial generic type inference

jan 21 René Vogt
14 views

select Id as [Post Link], Score, ViewCount from Posts wh...

jan 21 Musenga
14 views

select top 50000 Id as [Post Link], Score, ViewCount from...

jan 21 Musenga
10 views

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

jan 21
14 views

select top 4000 Id as [Post Link], Score, ViewCount from ...

jan 21 Musenga
12 views

select top 1000 Id as [Post Link], Score, ViewCount from ...

jan 21 Musenga
102 views

SELECT count(Id) FROM Badges where Name='Enlightened' and...

jan 21 jon.doe33023
12 views

select top 500 Id as [Post Link], Score, ViewCount from P...

jan 21 Musenga
12 views

select top 500 Id as [Post Link], Score, ViewCount from P...

jan 21 Musenga
23 views

select top 500 Id as [Post Link], Score, ViewCount from P...

jan 21 Musenga
33 views

Playground

jan 21 Trilarion
23 views

select top 50 Id as [Post Link], Score, ViewCount from Po...

jan 21 Musenga
102 views

SELECT badges.Id,badges.Name,badges.Date,users.DisplayNa...

jan 21 jon.doe33023
23 views

select top 50 Id as [Post Link], Score, ViewCount from Po...

jan 21 Musenga
23 views

select top 50 Id as [Post Link], Score, ViewCount from Po...

jan 21 Musenga
33 views

Playground

jan 21 Trilarion
33 views

Playground

jan 21 Trilarion
9 views

select TOP 50 Id as [Post Link], body, Score, ViewCount ...

jan 21 Musenga
33 views

Playground

jan 21 Trilarion
8 views

select TOP 50 Id as [Post Link], body, Score, ViewCount ...

jan 21 Musenga
23 views

select top 50 Id as [Post Link], Score, ViewCount from Po...

jan 21 Musenga
33 views

Playground

jan 21 Trilarion
33 views

Playground

jan 21 Trilarion
33 views

Playground

jan 21 Trilarion
33 views

Playground

jan 21 Trilarion
23 views

select top 500 Id as [Post Link], Score, ViewCount from P...

jan 21 Musenga
33 views

Playground

jan 21 Trilarion

30 50 100 per page