Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

60 views

select * from ( select UserId, TagId, row_number() over (...

jul 11 11 Brian Reichle
90 views

select top 10 Answers.OwnerUserId, PostTags.TagId, sum(An...

jul 11 11 Brian Reichle
94 views

select top 10 Answers.OwnerUserId, PostTags.TagId from Po...

jul 11 11 Brian Reichle
76 views

Update XML

jul 11 11 Mikael Eriksson
102 views

SELECT TOP 100 id AS [Post Link], Body FROM Posts WHERE ...

jul 11 11 staticbeast
74 views

SELECT TOP 100 id AS [Post Link], Body FROM Posts WHERE ...

jul 11 11 staticbeast
78 views

select top 1 Answers.OwnerUserId, PostTags.TagId from Pos...

jul 11 11 Brian Reichle
68 views

SELECT TOP 100 id AS [Post Link], Body FROM Posts WHERE ...

jul 11 11
115 views

World Cup of Reputation

jul 11 11 Scorpi0
91 views

World Cup of Reputation

jul 11 11 Scorpi0
106 views

World Cup of Reputation

jul 11 11 Scorpi0
100 views

World Cup of Reputation

jul 11 11 Scorpi0
106 views

set dateformat dmy declare @Rates table(Date datetime, R...

jul 11 11 Mikael Eriksson
55 views

Wild cardl like [

jul 11 11
75 views

Wild cardl like [

jul 11 11
56 views

Wild cardl like [

jul 11 11
54 views

Wild cardl like [

jul 11 11
78 views

Wild cardl like [

jul 11 11
59 views

Wild cardl like [

jul 11 11
81 views

Wild cardl like [

jul 11 11 Mikael Eriksson
6

12k views

World Cup of Reputation

jul 11 11 Scorpi0
3

6.7k views

World Cup of Reputation

jul 11 11 Scorpi0
2k views

World Cup of Reputation

jul 11 11 Scorpi0
1.9k views

World Cup of Reputation

jul 11 11 Scorpi0
1.4k views

World Cup of Reputation

jul 11 11 Scorpi0
830 views

World Cup of Reputation

jul 11 11 Scorpi0
955 views

World Cup of Reputation

jul 11 11 Scorpi0
994 views

World Cup of Reputation

jul 11 11 Scorpi0
914 views

World Cup of Reputation

jul 11 11 Scorpi0
320 views

World Cup of Reputation

jul 11 11 Scorpi0
788 views

World Cup of Reputation

jul 11 11 Scorpi0
389 views

World Cup of Reputation

jul 11 11 Scorpi0
381 views

World Cup of Reputation

jul 11 11 Scorpi0
1

1.6k views

World Cup of Reputation

jul 11 11 Scorpi0
179 views

World Cup of Reputation

jul 11 11 Scorpi0
185 views

World Cup of Reputation

jul 11 11 Scorpi0
77 views

World Cup of Reputation

jul 11 11 Scorpi0
104 views

World Cup of Reputation

jul 11 11 Scorpi0
77 views

World Cup of Reputation

jul 11 11 Scorpi0
41 views

World Cup of Latin American Reputation

jul 11 11 Scorpi0
50 views

World Cup of Latin American Reputation

jul 11 11 Scorpi0
40 views

World Cup of Latin American Reputation

jul 11 11 Scorpi0
49 views

World Cup of Latin American Reputation

jul 11 11 Scorpi0
583 views

World Cup of Reputation

jul 11 11 Scorpi0
501 views

World Cup of Reputation

jul 11 11 Scorpi0
540 views

World Cup of Reputation

jul 11 11 Scorpi0
586 views

World Cup of Reputation

jul 11 11 Scorpi0
238 views

World Cup of Reputation (no min user cut off)

jul 11 11 Scorpi0
285 views

World Cup of Reputation (no min user cut off)

jul 11 11 Scorpi0
281 views

World Cup of Reputation (no min user cut off)

jul 11 11 Scorpi0
1

1.2k views

World Cup of Reputation (no min user cut off)

jul 11 11 Scorpi0
417 views

World Cup of Reputation

jul 11 11 Scorpi0
585 views

World Cup of Reputation

jul 11 11 Scorpi0
461 views

World Cup of Reputation

jul 11 11 Scorpi0
466 views

World Cup of Reputation

jul 11 11 Scorpi0
436 views

World Cup of Reputation

jul 11 11 Scorpi0
428 views

World Cup of Reputation

jul 11 11 Scorpi0
379 views

World Cup of Reputation

jul 11 11 Scorpi0
475 views

World Cup of Reputation

jul 11 11 Scorpi0
471 views

World Cup of Reputation

jul 11 11 Scorpi0
488 views

World Cup of Reputation

jul 11 11 Scorpi0
418 views

World Cup of Reputation

jul 11 11 Scorpi0
324 views

World Cup of Reputation

jul 11 11 Scorpi0
449 views

World Cup of Reputation

jul 11 11 Scorpi0
491 views

World Cup of Reputation

jul 11 11 Scorpi0
429 views

World Cup of Reputation

jul 11 11 Scorpi0
470 views

World Cup of Reputation

jul 11 11 Scorpi0
171 views

World Cup of Reputation

jul 11 11 Scorpi0
148 views

World Cup of Reputation

jul 11 11 Scorpi0
258 views

World Cup of Reputation

jul 11 11 Scorpi0
160 views

World Cup of Reputation

jul 11 11 Scorpi0
139 views

World Cup of Reputation

jul 11 11 Scorpi0
211 views

World Cup of Reputation

jul 11 11 Scorpi0
171 views

World Cup of Reputation

jul 11 11 Scorpi0
171 views

World Cup of Reputation

jul 11 11 Scorpi0
142 views

World Cup of Reputation

jul 11 11 Scorpi0
129 views

World Cup of Reputation

jul 11 11 Scorpi0
125 views

World Cup of Reputation

jul 11 11 Scorpi0
375 views

World Cup of Reputation

jul 11 11 Scorpi0
229 views

World Cup of Reputation

jul 11 11 Scorpi0
164 views

World Cup of Reputation

jul 11 11 Scorpi0
145 views

World Cup of Reputation

jul 11 11 Scorpi0
251 views

World Cup of Reputation

jul 11 11 Scorpi0
262 views

World Cup of Reputation

jul 11 11 Scorpi0
534 views

World Cup of Reputation

jul 11 11 Scorpi0
181 views

World Cup of Reputation

jul 11 11 Scorpi0
234 views

World Cup of Reputation

jul 11 11 Scorpi0
206 views

World Cup of Reputation

jul 11 11 Scorpi0
266 views

World Cup of Reputation

jul 11 11 Scorpi0
264 views

Mundial de reputación

jul 11 11 Scorpi0
207 views

Mundial de reputación

jul 11 11 Scorpi0
265 views

Mundial de reputación

jul 11 11 Scorpi0
198 views

World Cup of Reputation

jul 11 11 Scorpi0
162 views

World Cup of Reputation

jul 11 11 Scorpi0
204 views

World Cup of Reputation

jul 11 11 Scorpi0
158 views

World Cup of Reputation

jul 11 11 Scorpi0
379 views

World Cup of Reputation

jul 11 11 Scorpi0
462 views

World Cup of Reputation

jul 11 11 Scorpi0
187 views

World Cup of Reputation

jul 11 11 Scorpi0
203 views

Mundial de reputación

jul 11 11 Scorpi0
201 views

Mundial de reputación

jul 11 11 Scorpi0
597 views

World Cup of Reputation

jul 11 11 Scorpi0
210 views

World Cup of Reputation

jul 11 11 Scorpi0
244 views

World Cup of Reputation

jul 11 11 Scorpi0
248 views

World Cup of Reputation

jul 11 11 Scorpi0
2

2.4k views

Mundial de reputación

jul 11 11 Scorpi0
277 views

World Cup of Reputation

jul 11 11 Scorpi0
350 views

World Cup of Reputation

jul 11 11 Scorpi0
351 views

World Cup of Reputation

jul 11 11 Scorpi0
317 views

World Cup of Reputation

jul 11 11 Scorpi0
391 views

World Cup of Reputation

jul 11 11 Scorpi0
405 views

World Cup of Reputation

jul 11 11 Scorpi0
294 views

World Cup of Reputation

jul 11 11 Scorpi0
388 views

World Cup of Reputation

jul 11 11 Scorpi0
385 views

World Cup of Reputation

jul 11 11 Scorpi0
1

1.9k views

World Cup of Reputation

jul 11 11 Scorpi0
133 views

World Cup of Reputation

jul 11 11 Scorpi0
68 views

Declare @t table(Data varchar(50)) Insert into @t Select ...

jul 11 11
65 views

Declare @t table(Data varchar(50)) Insert into @t Select ...

jul 11 11
81 views

Declare @t table(Data varchar(50)) Insert into @t Select ...

jul 11 11
108 views

select '-' + substring('', CHARINDEX(',','')+1, 1) + '-'

jul 11 11
125 views

select substring('', CHARINDEX(',','')+1, 1)

jul 11 11
118 views

Finding old, popular posts for closing

jul 11 11 sysadmin1138
81 views

select PostHistoryTypeId, COUNT(*) from PostHistory group...

jul 10 11
98 views

select creationdate from posts order by creationdate desc;

jul 10 11
114 views

Finding old, popular posts for closing

jul 10 11 sysadmin1138
111 views

Finding old, popular posts for closing

jul 10 11 sysadmin1138
103 views

select creationdate from posts order by creationdate;

jul 10 11
131 views

Finding old, popular posts for closing

jul 10 11 sysadmin1138
100 views

SELECT TOP 100 id AS [Post Link], Body FROM Posts WHERE ...

jul 10 11 staticbeast
111 views

SELECT id AS [Post Link], Body FROM Posts WHERE LEN(Body...

jul 10 11 staticbeast
81 views

SELECT * FROM ( SELECT '20:1:2:1' AS Data UNION SELECT '1...

jul 10 11
93 views

declare @t table (search varchar(max), txt varchar(max)) ...

jul 10 11 Mikael Eriksson
79 views

declare @t table (search varchar(max), txt varchar(max)) ...

jul 10 11
102 views

declare @t table (search varchar(max), txt varchar(max)) ...

jul 10 11
286 views

declare @t table (search varchar(max), txt varchar(max)) ...

jul 10 11
105 views

declare @t table (search varchar(max), txt varchar(max)) ...

jul 10 11
124 views

select 'http://stackoverflow.com/users/'+cast(id as varch...

jul 10 11
84 views

select 'stackoverflow.com/users/'+cast(id as varchar),Dis...

jul 10 11
92 views

select id,DisplayName,age,location,reputation from users ...

jul 10 11
89 views

select DisplayName,age,location,reputation from users whe...

jul 10 11
100 views

select DisplayName,age,location,reputation from users whe...

jul 10 11
114 views

select DisplayName,age,location from users where Location...

jul 10 11
97 views

select DisplayName from users where Location like '%Ukrai...

jul 10 11
115 views

select DisplayName from users where Location like '%Ukrai...

jul 10 11
96 views

select DisplayName from users where Location = 'Ukraine'

jul 10 11
1

3.1k views

Per Tag User Awesomeness

jul 10 11 Brian Reichle
214 views

Per Tag User Awesomeness

jul 10 11 Brian Reichle
207 views

Per Tag User Awesomeness

jul 10 11 Brian Reichle
259 views

Per Tag User Awesomeness

jul 10 11 Brian Reichle
233 views

Per Tag User Awesomeness

jul 10 11 Brian Reichle
279 views

Per Tag User Awesomeness

jul 10 11 Brian Reichle
242 views

Per Tag User Awesomeness

jul 10 11 Brian Reichle
112 views

Per Tag User Awesomeness

jul 10 11 Brian Reichle
99 views

Per Tag User Awesomeness

jul 10 11 Brian Reichle
112 views

select TagName, Score, Answers, Tags.Count, 1.00 * Score ...

jul 10 11 Brian Reichle
129 views

select TagName, Score, Answers, Tags.Count, 1.00 * Score ...

jul 10 11 Brian Reichle
122 views

select TagName, Score, Answers, Tags.Count, 1.00 * Score ...

jul 10 11 Brian Reichle
103 views

select TagName, Score, Answers, Tags.Count, 1.00 * Score ...

jul 10 11 Brian Reichle
127 views

select TagName, Score, Answers, Tags.Count, 1.00 * Score ...

jul 10 11 Brian Reichle
118 views

select TagName, Score, Answers, Tags.Count, 1.00 * Score ...

jul 10 11 Brian Reichle
106 views

select TagName, Score, Answers from ( select sum(Posts.Sc...

jul 10 11 Brian Reichle
102 views

select Question.Id, Answer.Id, Question.Title, Answer.Sco...

jul 10 11 Brian Reichle
106 views

select Question.Id, Answer.Id, Question.Title, Answer.Score

jul 10 11 Brian Reichle
124 views

select Question.Id, Answer.Id, Question.Title, Answer.Score

jul 10 11 Brian Reichle
107 views

select Question.Title, Answer.Score from Posts as Answer ...

jul 10 11 Brian Reichle
96 views

select Question.Title, Answer.Score, PostTags.TagId from ...

jul 10 11 Brian Reichle
83 views

select Question.Title, Answer.Score, PostTags.TagId from ...

jul 10 11 Brian Reichle
96 views

select Posts.Title, Posts.Score, PostTags.TagId from Post...

jul 10 11 Brian Reichle
96 views

select TagName, Score, Answers from ( select sum(Posts.Sc...

jul 10 11 Brian Reichle
80 views

select TagName, Score from ( select sum(Posts.Score) Score,

jul 10 11 Brian Reichle
114 views

select TagName, Score from ( select sum(Posts.Score) Score,

jul 10 11 Brian Reichle
114 views

select Posts.Id, Posts.Score, PostTags.PostId, PostTags.T...

jul 10 11 Brian Reichle
97 views

select Posts.Id, Posts.Score, PostTags.PostId, PostTags.T...

jul 10 11 Brian Reichle
92 views

select Posts.Id, Posts.Score, PostTags.PostId, PostTags.T...

jul 10 11 Brian Reichle
113 views

select top 1 * from PostTags

jul 10 11 Brian Reichle
87 views

select Posts.Id, Posts.Score, PostTags.TagId, TagName fro...

jul 10 11 Brian Reichle
109 views

select Posts.Id, Posts.Score, TagName from Posts left joi...

jul 10 11 Brian Reichle
78 views

select * from Posts join PostTags on PostId = Posts.Id jo...

jul 10 11 Brian Reichle
83 views

select * from Posts where PostTypeId = 2 and OwnerUserId ...

jul 10 11 Brian Reichle
73 views

select * from Posts where PostTypeId = 1 and OwnerUserId ...

jul 10 11 Brian Reichle
96 views

select Id [User Link], Reputation, DisplayName, Location ...

jul 10 11
83 views

How Many Edits Have I Made?

jul 10 11
89 views

select Score, Answers, count(*) as Count from ( select a...

jul 10 11
70 views

select top 1000 Score, Answers, count(*) as Count from (...

jul 10 11
71 views

select top 1000 Score, Answers, count(*) as Count from (...

jul 10 11
104 views

select top 1000 Month, Year, Score, Answers, count(*) from

jul 10 11
74 views

select top 10 month(CreationDate) as Month, year(Creatio...

jul 10 11
80 views

select top 10 month(CreationDate) as Month, year(Creatio...

jul 10 11
94 views

select top 10 month(CreationDate) as Month, year(Creatio...

jul 10 11
82 views

select top 10 month(CreationDate), year(CreationDate), S...

jul 10 11
137 views

select top 50 * from Votes where VoteTypeId = 6

jul 9 11 Jon Seigel
2.3k views

Response time: distribution in hours until accepted answer

jul 9 11 Jan Fabry
489 views

Response time: distribution in hours until accepted answer

jul 9 11 Jan Fabry
402 views

Response time: distribution in hours until accepted answer

jul 9 11 Jan Fabry
147 views

Average time until accepted answer was added

jul 9 11 Jan Fabry
142 views

SELECT TOP 50 * FROM Users

jul 9 11 Jon Seigel
94 views

select * from information_schema.columns where table_name...

jul 9 11 Jon Seigel
110 views

Average time until accepted answer was added

jul 9 11 Jan Fabry
105 views

Average time until accepted answer was added

jul 9 11 Jan Fabry
102 views

Average time until accepted answer was added

jul 9 11 Jan Fabry
121 views

Average time until accepted answer was added

jul 9 11 Jan Fabry
107 views

Average time until accepted answer was added

jul 9 11 Jan Fabry

30 50 100 per page

1,412,780

queries

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

12k questions

27k answers

88k comments

986 tags

dec 8 most recent