Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

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

jan 24
2 views

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

jan 24
2 views

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

jan 24
2 views

SELECT AVG(YEAR(GETDATE()) - YEAR(CreationDate )) FROM Us...

jan 24
3 views

select Body from Posts where CreationDate >= '2014-01-01'...

jan 24
3 views

SELECT AVG(YEAR(CreationDate )- YEAR(GETDATE())) FROM Use...

jan 24
3 views

select CAST(0x3C3F54657374696E672075706C6F61643F3E3C666F6...

jan 24
3 views

SELECT GETDATE();

jan 24
1

85 views

Users by number of a specific badge

jan 24 Glorfindel
1

85 views

Users by number of a specific badge

jan 24 Glorfindel
5 views

select Body from Posts where CreationDate >= '2015-01-01'...

jan 24
11 views

Privileges awarded

jan 24 Fabby
5 views

SELECT LastAccessDate FROM Users;

jan 24
7 views

select Body from Posts where CreationDate >= '2016-01-01'...

jan 24
8 views

select Body from Posts where CreationDate >= '2017-01-01'...

jan 24
9 views

SELECT u.DisplayName, COUNT(b.Id) as 'Number of Enlighten...

jan 24
9 views

SELECT u.DisplayName, COUNT(b.Id) FROM Users u, Badges b ...

jan 24
9 views

SELECT b.* FROM Badges b WHERE LOWER(b.Name) = LOWER('Enl...

jan 24
10 views

SELECT * FROM Badges WHERE LOWER(Name) = LOWER('Enlighten...

jan 24
10 views

SELECT u.DisplayName, COUNT(b.Id) FROM Users u, Badges b ...

jan 24
10 views

SELECT * FROM Badges WHERE LOWER(Name) = LOWER('Enlighten...

jan 24
10 views

SELECT u.Id, u.Reputation, u.DisplayName, u.Location FROM...

jan 24
10 views

select Body from Posts where CreationDate >= '2018-01-01'...

jan 24
10 views

select Body from Posts where CreationDate >= '2019-01-01'...

jan 24
43 views

Wilson confidence rating for posts of a user

jan 24 rene
43 views

Wilson confidence rating for posts of a user

jan 24 rene
11 views

SELECT * FROM Badges WHERE LOWER(Name) = LOWER('Enlighten...

jan 24
11 views

SELECT COUNT(Id) FROM Users;

jan 24
11 views

SELECT YEAR(CreationDate) as 'Year', COUNT(Id) as 'Number...

jan 24
11 views

SELECT * FROM Badges;

jan 24
12 views

SELECT Id, Reputation, DisplayName, Location FROM Users W...

jan 24
12 views

SELECT Id, Reputation, DisplayName, Location FROM Users W...

jan 24
12 views

select Body from Posts where CreationDate >= '2019-01-01'...

jan 24
12 views

SELECT Id, Reputation, DisplayName, Location FROM Users;

jan 24
12 views

select Body from Posts where CreationDate > '2019-01-01' ...

jan 24
12 views

select Body from Posts where CreationDate > '2019-01-01' ...

jan 24
12 views

select Body from Posts where CreationDate > '2019-01-01' ...

jan 24
21 views

Popular tags with Neo4j

jan 24
12 views

SELECT Id, Reputation, DisplayName FROM Users;

jan 24
43 views

Wilson confidence rating for posts of a user

jan 24 rene
12 views

select Body from Posts where CreationDate > '2019-01-01'

jan 24
43 views

Wilson confidence rating for posts of a user

jan 24 rene
43 views

Wilson confidence rating for posts of a user

jan 24 rene
12 views

select Body from Posts where Id>59807000

jan 24
12 views

select Body from Posts where Id>50000000

jan 24
12 views

select max(id) from Posts

jan 24
12 views

select min(id) from Posts

jan 24
43 views

Wilson confidence rating for posts of a user

jan 24 rene
12 views

select count(id) from Posts

jan 24
12 views

select count(id) from Posts

jan 24
12 views

select count(id) from Posts

jan 24
12 views

select count(id) from Posts

jan 24
12 views

select count(id) from Posts

jan 24
12 views

select count(id) from Posts

jan 24
14 views

select count(id) from Posts

jan 24
12 views

select count(id) from Posts

jan 24
12 views

select count(id) from Posts

jan 24
12 views

select count(id) from Posts

jan 24
10 views

select count(id) from Posts

jan 24
10 views

select count(id) from Posts

jan 24
8 views

select count(id) from Posts

jan 24
7 views

select count(id) from Posts

jan 24
5 views

select count(id) from Posts

jan 24
3 views

select count(id) from Posts

jan 24
43 views

Wilson confidence rating for posts of a user

jan 24 rene
21 views

Most controversial users of a site, v2

jan 24 David.Hammen
43 views

Wilson confidence rating for posts of a user

jan 24 rene
12 views

SELECT COUNT(p.Id) 'Number of Question by Mat Mannion' FR...

jan 24
21 views

Most controversial users of a site, v2

jan 24 David.Hammen
43 views

Wilson confidence rating for posts of a user

jan 24 rene
12 views

SELECT COUNT(p.Id) FROM Users u, Posts p, PostTypes pt WH...

jan 24
13 views

SELECT title,concat('https://stackoverflow.com/questions/...

jan 24
13 views

SELECT title,concat('https://stackoverflow.com/questions/...

jan 24
13 views

SELECT q.title,concat('https://stackoverflow.com/question...

jan 24
13 views

SELECT q.title,concat('https://stackoverflow.com/question...

jan 24
13 views

SELECT q.title,concat('https://stackoverflow.com/question...

jan 24
13 views

SELECT q.title,concat('https://stackoverflow.com/question...

jan 24
13 views

SELECT title,concat('https://stackoverflow.com/questions/...

jan 24
12 views

SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#]...

jan 24
11 views

SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#]...

jan 24
11 views

SELECT title,concat('https://stackoverflow.com/questions/...

jan 24
11 views

SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#]...

jan 24
12 views

SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#]...

jan 24
11 views

SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#]...

jan 24
11 views

SELECT questions.Id as [Post Link], questions.title, answ...

jan 24
18 views

Top 100 users from Pakistan

jan 24
18 views

test

jan 24
11 views

select * from Posts where Tags='python';

jan 24
11 views

select * from Posts where Tags='python';

jan 24
18 views

test

jan 24
11 views

select * from Posts;

jan 24
18 views

test

jan 24
21 views

test

jan 24
18 views

test

jan 24
10 views

SELECT YEAR(CreationDate) as 'Year', COUNT(Id) as 'Number...

jan 24
10 views

SELECT YEAR(CreationDate) as 'Year', COUNT(Id) FROM Users...

jan 24
10 views

SELECT YEAR(CreationDate) as 'Year', COUNT(Id) FROM Users...

jan 24
10 views

SELECT DISTINCT YEAR(CreationDate) as 'Year', COUNT(Id) F...

jan 24
10 views

SELECT DISTINCT YEAR(CreationDate) as 'Year', COUNT(Id) F...

jan 24
10 views

SELECT YEAR(CreationDate) as 'Year', COUNT(Id) FROM Users...

jan 24
10 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
10 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
10 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
10 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
10 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
10 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
10 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
12 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
12 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
12 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
10 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
11 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
10 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
10 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
10 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
9 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
12 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
12 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
12 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
11 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
11 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
11 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
3 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
2 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
5 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
3 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
9 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
9 views

SELECT CreationDate, COUNT(Id) FROM Users GROUP BY Creati...

jan 24
10 views

SELECT P.Tags, COUNT(*) as count FROM Posts as P WHERE P....

jan 24
19 views

Popular tags with Neo4j

jan 24
21 views

Popular tags with Neo4j

jan 24
19 views

Fairness

jan 24
19 views

Loicense Check

jan 24
19 views

Loicense Check

jan 24
19 views

Fairness

jan 24
19 views

Fairness

jan 24
19 views

Top AWS tags - Answered (past 3 months)

jan 24
19 views

Loicense Check

jan 24
11 views

SELECT TOP 1000 P.Tags, COUNT(*) as count FROM Posts as P...

jan 24
19 views

Top AWS tags - Answered (past 3 months)

jan 24
19 views

Loicense Check

jan 24
11 views

SELECT TOP 100 P.Tags, COUNT(*) as count FROM Posts as P ...

jan 24
11 views

SELECT TOP 100 P.Tags FROM Posts as P WHERE P.Tags LIKE '...

jan 24
11 views

SELECT TOP 100 P.Id as [Post Link], P.Tags, P.CreationDat...

jan 24
11 views

SELECT TOP 100 P.Id as [Post Link], P.Tags, P.CreationDat...

jan 24
20 views

Loicense Check

jan 24
11 views

SELECT TOP 100 P.Id as [Post Link], P.Tags, P.CreationDat...

jan 24
20 views

Loicense Check

jan 24
20 views

Loicense Check

jan 24
19 views

Loicense Check

jan 24
19 views

Loicense Check

jan 24
19 views

Loicense Check

jan 24
19 views

Loicense Check

jan 24
10 views

SELECT q.Id, q.Title, q.body,q.Tags,q.CreationDate,q.Acc...

jan 24

30 50 100 per page