Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

241 views

Top Stack Overflow users from Pakistan by reputation

nov 21 14 Salman von Abbas
293 views

select * from posts where id = 918762

nov 21 14 robjohn
293 views

select * from users where id = 21436

nov 21 14 robjohn
1.1k views

Find interesting unanswered questions

nov 21 14
11 views

DECLARE @UserId int = 3049002 SELECT 100 - COUNT(*) AS '...

nov 21 14
19 views

select * from Posts where id = 26953581 ;

nov 21 14
12 views

select max(id) from Posts ;

nov 21 14
19 views

select max(id) from Posts ;

nov 21 14
18 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

nov 21 14
16 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

nov 21 14
15 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

nov 21 14
17 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

nov 21 14
15 views

SELECT COUNT(*), SUM(CASE WHEN Score > 1 THEN 1 ELSE 0 EN...

nov 21 14
16 views

SELECT COUNT(*), SUM(CASE WHEN Score > 0 THEN 1 ELSE 0 EN...

nov 21 14
14 views

SELECT COUNT(*) FROM Posts

nov 21 14
16 views

SELECT COUNT(*) FROM Posts

nov 21 14
15 views

SELECT COUNT(*) FROM Posts

nov 21 14
16 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

nov 21 14
10 views

select top 100 * from Posts as P left outer join Users as...

nov 21 14
159 views

SELECT v.UserId, vt.Name, COUNT(*) FROM Posts p INNER JOIN Votes v ON v.Pos

nov 21 14
149 views

SELECT v.UserId, vt.Name, COUNT(*) FROM Posts p INNER JOIN Votes v ON v.Pos

nov 21 14
11 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

nov 21 14
16 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

nov 21 14
17 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

nov 21 14
15 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

nov 21 14
16 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

nov 21 14
18 views

WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER...

nov 21 14
140 views

SELECT v.UserId, vt.Name, COUNT(*) FROM Posts p INNER JOIN Votes v ON v.Pos

nov 21 14
635 views

How many upvotes do I have for each tag?

nov 21 14
648 views

How many upvotes do I have for each tag?

nov 21 14
609 views

How many upvotes do I have for each tag?

nov 21 14
615 views

How many upvotes do I have for each tag?

nov 21 14
633 views

How many upvotes do I have for each tag?

nov 21 14
199 views

inner join attempt 1

nov 21 14
314 views

Top posts with tag html (test)

nov 21 14
177 views

Top posts with tag html (test)

nov 21 14
143 views

Top posts with tag html (test)

nov 21 14
141 views

Top posts with tag html (test)

nov 21 14
182 views

Top posts with tag html (test)

nov 21 14
166 views

Top posts with tag html (test)

nov 21 14
134 views

Top posts with tag html (test)

nov 21 14
136 views

Top posts with tag html (test)

nov 21 14
117 views

Top posts with tag html (test)

nov 21 14
99 views

select CAST(0x3C68746D6C202020202020202020202020202020202...

nov 21 14
12 views

select * from ReviewTasks

nov 21 14
14 views

select Posts.Id,Body from Posts where Posts.Id = '622246'

nov 21 14
15 views

select Posts.Id,Body from Posts where Posts.Id in ('13301...

nov 21 14
16 views

select Posts.Id,Posts.Tags,Body from Posts where Posts.Id...

nov 21 14
11 views

select * from ReviewTaskStates

nov 21 14
12 views

select * from ReviewTaskStates

nov 21 14
164 views

test

nov 21 14 Jason C
139 views

lets see user descriptions

nov 21 14
376 views

find users with about me text like

nov 21 14
49 views

lets see user descriptions

nov 21 14
61 views

lets see user descriptions

nov 21 14
60 views

lets see user descriptions

nov 21 14
68 views

lets see user descriptions

nov 21 14
45 views

lets see user descriptions

nov 21 14
79 views

lets see user descriptions

nov 21 14
45 views

lets see user descriptions

nov 21 14
105 views

lets see user descriptions

nov 21 14
132 views

find users with about me text like

nov 21 14
136 views

find users with about me text like

nov 21 14
202 views

test

nov 21 14 Jason C
177 views

test

nov 21 14 Jason C
204 views

test

nov 21 14 Jason C
188 views

test

nov 21 14 Jason C
202 views

test

nov 21 14
727 views

AFAIK Replies

nov 21 14 Jason C
727 views

AFAIK Replies

nov 21 14 Jason C
162 views

test

nov 21 14
236 views

UUID Usernames

nov 21 14 Jason C
177 views

test

nov 21 14
204 views

test

nov 21 14
188 views

test

nov 21 14
202 views

test

nov 21 14
162 views

test

nov 21 14
170 views

test

nov 21 14
164 views

test

nov 21 14
202 views

test

nov 21 14
18 views

select Posts.Id,Posts.Tags,Body from Posts where Posts.Id...

nov 21 14
14 views

select Posts.Id,Posts.Title,TagName,Posts.Tags,Posts.Crea...

nov 21 14
15 views

select Posts.Id,Posts.Title,TagName,Posts.Tags,Posts.Crea...

nov 21 14
16 views

select Posts.Id,Posts.Title,TagName,Posts.Tags,Posts.Crea...

nov 21 14
18 views

select Posts.Id,Posts.Title,TagName,Posts.Tags,Posts.Crea...

nov 21 14
11 views

select Posts.Id,Posts.Title,TagName,Posts.Tags,Posts.Crea...

nov 21 14
188 views

test

nov 21 14
202 views

test

nov 21 14
162 views

test

nov 21 14
170 views

test

nov 21 14
281 views

test

nov 21 14
204 views

test

nov 21 14
177 views

test

nov 21 14
202 views

test

nov 21 14
164 views

test

nov 21 14
727 views

AFAIK Replies

nov 21 14 Jason C
727 views

AFAIK Replies

nov 21 14 Jason C
727 views

AFAIK Replies

nov 21 14 Jason C
2

8.5k views

Closes per week

nov 21 14 Jon "not doe" Ericson
2

8.5k views

Closes per week

nov 21 14 Jon "not doe" Ericson
2

8.5k views

Closes per week

nov 21 14 Jon "not doe" Ericson
2

8.5k views

Closes per week

nov 21 14 Jon "not doe" Ericson
13 views

SELECT link, cnt, id [Post Link], score FROM ( SELECT...

nov 21 14
2

8.5k views

Closes per week

nov 21 14 Jon "not doe" Ericson
269 views

High-Rep Users by Reputation Per Day

nov 21 14 jon.doe14699
355 views

High-Rep Users by Reputation Per Day

nov 21 14 jon.doe14699
381 views

Number of users by reputation range (15K-75K)

nov 21 14 jon.doe14699
1

951 views

High-Rep Users by Reputation Per Day

nov 21 14 jon.doe14699
323 views

Number of users by reputation range (15K-75K)

nov 21 14 jon.doe14699
295 views

Number of users by reputation range (15K-75K)

nov 21 14 jon.doe14699
352 views

Users by reputation range (15K-75K)

nov 21 14 jon.doe14699
484 views

Users by reputation range (15K-75K)

nov 21 14 jon.doe14699
464 views

Users by reputation range (15K-75K)

nov 21 14 jon.doe14699
110 views

Number of users by reputation range (15K-75K)

nov 21 14 jon.doe14699
17 views

SELECT DisplayName, Reputation FROM Users;

nov 21 14
17 views

SELECT DisplayName, Reputation FROM Users;

nov 21 14
18 views

SELECT u.DisplayName, u.Reputation FROM Users u;

nov 21 14
22 views

SELECT u.DisplayName, u.Reputation FROM Users u WHERE u.R...

nov 21 14
20 views

SELECT u.DisplayName, u.Reputation FROM Users u WHERE u.R...

nov 21 14
18 views

SELECT DisplayName FROM Users;

nov 21 14
17 views

SELECT Id FROM Users;

nov 21 14
17 views

SELECT Id FROM Users;

nov 21 14
13 views

SELECT Id FROM Users;

nov 21 14
18 views

SELECT Id FROM Users;

nov 21 14
20 views

SELECT Id FROM Users;

nov 21 14
22 views

SELECT Id FROM Users;

nov 21 14
18 views

SELECT Id FROM Users;

nov 21 14
19 views

SELECT * FROM Posts

nov 21 14
12 views

SELECT * FROM Posts

nov 21 14
32 views

SELECT * FROM Comments WHERE Text LIKE '%must be fun%'

nov 21 14
21 views

SELECT * FROM Comments WHERE Text LIKE '%must be fun%'

nov 21 14
31 views

SELECT * FROM Comments WHERE Text LIKE '%you must be fun%'

nov 21 14
32 views

SELECT * FROM Comments WHERE Text LIKE '%fun at parties%'

nov 21 14
21 views

SELECT * FROM Comments WHERE Text LIKE '%fun at parties%'

nov 21 14
31 views

SELECT * FROM Comments WHERE Text LIKE '%fun at parties%'

nov 21 14
23 views

SELECT * FROM Comments WHERE Text LIKE '%fun at parties%'

nov 21 14
62 views

select * from Posts where OwnerUserId = 1019607

nov 21 14 jon.doe16096
62 views

select * from Users where DisplayName = 'int21h'

nov 21 14 jon.doe16096
39 views

select * from Users where DisplayName like '%MrPeanut%'

nov 21 14
35 views

select * from Users where DisplayName like '%MrPnut%'

nov 21 14
39 views

select count(Id) from Posts

nov 21 14
35 views

select count(Id) from Posts

nov 21 14
22 views

select count(Id) from Posts

nov 21 14
232 views

Sexist Posts

nov 21 14 Jason C
232 views

Sexist Posts

nov 21 14 Jason C
176 views

Sexist Posts

nov 21 14 Jason C
38 views

SELECT Id AS [User Link],ProfileImageUrl, Reputation, Web...

nov 21 14
36 views

SELECT Id AS [User Link],ProfileImageUrl, Reputation, Web...

nov 21 14
203 views

Counting 'Copy Editors'

nov 21 14
30 views

SELECT Id AS [User Link],ProfileImageUrl, Reputation, Web...

nov 21 14
33 views

SELECT Id AS [User Link],ProfileImageUrl, Reputation FROM...

nov 21 14
35 views

SELECT Id AS [User Link],ProfileImageUrl, Reputation FROM...

nov 21 14
37 views

SELECT Id AS [User Link],ProfileImageUrl, Reputation FROM...

nov 21 14
33 views

SELECT SO_ID, PHY, PHM, count(*) as Edits FROM ( select p...

nov 21 14
39 views

SELECT Id AS [User Link],ProfileImageUrl, Reputation FROM...

nov 21 14
39 views

SELECT u.Id as SO_ID, year(p.CreationDate) as PY, month(p...

nov 21 14
31 views

SELECT Id AS [User Link] FROM Users WHERE Age < 20

nov 21 14
47 views

select p1.id, count(*), p1.title from posts p1, posts p2,...

nov 21 14
35 views

SELECT Id AS [Users Link] FROM Users WHERE Age < 20

nov 21 14

30 50 100 per page

1,653,651

queries

Q&A for committed Christians, experts in Christianity and those interested in learning more

13k questions

29k answers

98k comments

1.1k tags

jan 17 most recent