Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

84 views

SELECT COUNT(1) FROM PostTags pt WHERE pt.TagId = (SELEC...

may 8 11 Jon Seigel
70 views

SELECT * FROM Tags WHERE TagName = 'c#'

may 8 11 Jon Seigel
130 views

Unanswered questions per tag (not complete)

may 8 11 Jon Seigel
85 views

SELECT TOP 500 a.TagName, a.UnansweredCount, CAST((100.0...

may 8 11 Jon Seigel
82 views

SELECT TOP 500 a.TagName, a.ZeroAnswerCount, CAST((100.0...

may 8 11 Jon Seigel
132 views

SELECT TOP 500 a.TagName, a.ZeroAnswerCount, (100.0 * a....

may 8 11 Jon Seigel
100 views

SELECT TOP 500 a.TagName, a.Count FROM ( SELECT t.TagName,

may 8 11 Jon Seigel
99 views

SELECT t.TagName, COUNT(1) AS Count FROM Posts p INNER J...

may 8 11 Jon Seigel
97 views

SELECT TOP 100 * FROM Posts p INNER JOIN PostTags pt ON ...

may 8 11 Jon Seigel
3k views

Search Posts

may 8 11 YOU
141 views

Search Posts

may 8 11 YOU
520 views

Search Posts

may 8 11 YOU
151 views

Search Posts

may 8 11 YOU
164 views

Search Posts

may 8 11 YOU
157 views

Search Posts

may 8 11 YOU
196 views

Search Posts

may 8 11 YOU
164 views

Search Posts

may 8 11 YOU
49 views

Search Posts

may 8 11 YOU
31 views

Search Posts

may 8 11 YOU
1

201 views

Search Posts

may 8 11 YOU
73 views

DECLARE @UserId int = ##UserId## SELECT COUNT(*) as 'Edi...

may 8 11
79 views

Top users by tag

may 8 11
82 views

Highest rated posts

may 8 11 Arda Xi
85 views

Highest rated posts

may 8 11 Arda Xi
2.2k views

Question score by time of day

may 7 11 Gilles
188 views

Question score by time of day

may 7 11 Gilles
201 views

Question score by time of day

may 7 11 Gilles
226 views

Question score by week number

may 7 11 Gilles
213 views

Question score by week number

may 7 11 Gilles
210 views

Question score by week number

may 7 11 Gilles
193 views

Question score by week number

may 7 11 Gilles
206 views

Question score by week number

may 7 11 Gilles
304 views

Question score by week number

may 7 11 Gilles
188 views

Question score by day number

may 7 11 Gilles
211 views

Question score by day number

may 7 11 Gilles
201 views

Question score by week number

may 7 11 Gilles
444 views

Question score by week number

may 7 11 Gilles
235 views

Question score by week number

may 7 11 Gilles
240 views

Question score by week number

may 7 11 Gilles
156 views

Question score by week number

may 7 11 Gilles
206 views

Question score by week number

may 7 11 Gilles
681 views

Question score by week number

may 7 11 Gilles
214 views

Question score by week number

may 7 11 Gilles
205 views

Question score by week number

may 7 11 Gilles
198 views

Question score by week number

may 7 11 Gilles
196 views

Question score by week number

may 7 11 Gilles
228 views

Question score by week number

may 7 11 Gilles
176 views

Question score by week number

may 7 11 Gilles
227 views

Question score by week number

may 7 11 Gilles
185 views

Question score by week number

may 7 11 Gilles
173 views

Question score by week number

may 7 11 Gilles
263 views

Question score by week number

may 7 11 Gilles
187 views

Question score by week number

may 7 11 Gilles
216 views

Question score by week number

may 7 11 Gilles
247 views

Question score by week number

may 7 11 Gilles
252 views

Question score by week number

may 7 11 Gilles
313 views

Question score by week number

may 7 11 Gilles
200 views

Question score by week number

may 7 11 Gilles
189 views

Question score by week number

may 7 11 Gilles
226 views

Question score by week number

may 7 11 Gilles
176 views

Question score by week number

may 7 11 Gilles
209 views

Question score by week number

may 7 11 Gilles
220 views

Question score by week number

may 7 11 Gilles
112 views

Question score by time of day

may 7 11 Gilles
134 views

Question score by time of day

may 7 11 Gilles
99 views

Question score by time of day

may 7 11 Gilles
104 views

Question score by time of day

may 7 11 Gilles
120 views

Question score by time of day

may 7 11 Gilles
119 views

Question score by time of day

may 7 11 Gilles
89 views

Question score by time of day

may 7 11 Gilles
135 views

Question score by time of day

may 7 11 Gilles
91 views

Question score by time of day

may 7 11 Gilles
103 views

Question score by time of day

may 7 11 Gilles
88 views

Zero-score questions by time of day

may 7 11 Gilles
103 views

Zero-score questions by time of day

may 7 11 Gilles
106 views

Zero-score questions

may 7 11 Gilles
119 views

Zero-score questions

may 7 11 Gilles
97 views

Zero-score questions

may 7 11 Gilles
123 views

Zero-score questions

may 7 11 Gilles
107 views

Zero-score questions

may 7 11 Gilles
174 views

Zero-score questions

may 7 11 Gilles
92 views

Zero-score questions

may 7 11 Gilles
118 views

Zero-score questions

may 7 11 Gilles
96 views

100 longest posts

may 7 11 Gilles
126 views

100 longest posts

may 7 11 Gilles
140 views

100 longest posts

may 7 11 Gilles
92 views

select top 30 * from tags order by count desc;

may 7 11
75 views

select top 20 * from tags order by count desc;

may 7 11
161 views

SELECT VoteTypeId, COUNT(VoteTypeId) FROM Votes GROUP BY...

may 7 11 BenP
144 views

SELECT TOP 100 * FROM Votes WHERE VoteTypeId = 15

may 7 11 BenP
147 views

SELECT VoteTypeId, COUNT(VoteTypeId) FROM Votes GROUP BY...

may 7 11 BenP
104 views

SELECT VoteTypeId, COUNT(VoteTypeId) FROM Votes GROUP BY...

may 7 11 BenP
125 views

SELECT VoteTypeId, COUNT(VoteTypeId) FROM Votes GROUP BY...

may 7 11 BenP
167 views

SELECT COUNT(*) FROM Votes WHERE VoteTypeId = 6

may 7 11 BenP
163 views

SELECT COUNT(*) FROM Votes WHERE VoteTypeId = 7

may 7 11 BenP
134 views

SELECT TOP 10 * FROM Votes WHERE VoteTypeId = 7

may 7 11 BenP
150 views

SELECT TOP 10 * FROM Votes WHERE VoteTypeId = 4

may 7 11 BenP
178 views

SELECT TOP 100 * FROM Votes

may 7 11 BenP
123 views

select top 100 DisplayName, UpVotes, Views, LastAccessDa...

may 7 11
98 views

select top 100 DisplayName, UpVotes, Views, LastAccessDa...

may 7 11
99 views

select top 100 DisplayName, UpVotes, Views from Users or...

may 7 11
98 views

select top 100 DisplayName, Views from Users order by Up...

may 7 11
106 views

select top 100 DisplayName, Views from Users order by Vi...

may 7 11
104 views

select displayname,reputation from users where id < 1000 ...

may 7 11
114 views

select displayname,reputation from users where id < 1000;

may 7 11
127 views

select top 100 Id, Views from Users order by Views

may 7 11
115 views

select top 100 DisplayName, Views from Users order by Vi...

may 7 11
75 views

select id from users where id < 1000;

may 7 11
114 views

select * from users where id < 1000;

may 7 11
139 views

select top 10 * from tags order by count desc;

may 7 11
115 views

select top 100 DisplayName, UpVotes from Users order by ...

may 7 11
125 views

select top 10 * from tags order by count;

may 7 11
126 views

select top 100 DisplayName from Users order by UpVotes

may 7 11
124 views

select userid from votes where id < 10000;

may 7 11
126 views

select * from votes where userid < 1000;

may 7 11
123 views

select * from votes where id < 1000;

may 7 11
125 views

select * from votes;

may 7 11
126 views

select top 10 * from tags ;

may 7 11
118 views

select * from users where Id = 576752

may 7 11
127 views

SELECT TOP 30 Id, DisplayName, Reputation, WebsiteUrl, Lo...

may 7 11
149 views

SELECT TOP 1 * FROM Posts

may 7 11 BenP
134 views

SELECT TOP 30 Id, DisplayName, Reputation, WebsiteUrl, Lo...

may 7 11
131 views

SELECT Body FROM Posts WHERE Body LIKE '%m not a programm...

may 7 11
108 views

SELECT Body FROM Posts WHERE Body LIKE '%not a programmer...

may 7 11
103 views

SELECT * FROM Posts WHERE Body LIKE '%not a programmer%';

may 7 11
170 views

select id [Post Link], len(body) , score from posts w...

may 7 11 conradfrix
166 views

select id [Post Link], len(body) from posts where owner...

may 7 11 conradfrix
134 views

select id, len(body) [Postlink] from posts where ownerus...

may 7 11 conradfrix
155 views

select id, len(body) [PostLink] from posts where ownerus...

may 7 11 conradfrix
166 views

select id, len(body) [Post Link] from posts where owneru...

may 7 11 conradfrix
188 views

select id, len(body) from posts where owneruserid=119477...

may 7 11 conradfrix
211 views

select len(body) from posts where owneruserid=119477

may 7 11 conradfrix
178 views

select * from posts where owneruserid=119477

may 7 11 conradfrix
157 views

Lesser Questions with Good Answers

may 7 11 mattdm
120 views

Lesser Questions with Good Answers

may 7 11 mattdm
97 views

Recent insightful comments

may 7 11
246 views

SELECT * FROM Users WHERE Id = 33884

may 6 11 BenP
109 views

select a.OwnerUserId as [User Link], a.Id as [Post Link],...

may 6 11
132 views

select a.OwnerUserId as [User Link], a.Id as [Post Link],...

may 6 11
118 views

Select top 50000 score, avg(cast(score as float)/viewcou...

may 6 11 Sklivvz
165 views

Select top 50000 score, avg(cast(score as float)/viewcou...

may 6 11 Sklivvz
128 views

Select top 50000 score, avg(cast(score as float)/viewcou...

may 6 11 Sklivvz
159 views

create table #ranks (views bigint, score int, rank bigint)

may 6 11 Sklivvz
154 views

create table #ranks (views bigint, score int, rank bigint)

may 6 11 Sklivvz
162 views

create table #ranks (views bigint, score int, rank bigint)

may 6 11 Sklivvz
135 views

select * from tags where id in (select top 40 tagid from ...

may 6 11
142 views

select * from tags where id in (select top 40 tagid from ...

may 6 11
117 views

Select u.Id As [User Link], (sum(coalesce(datalength(p.B...

may 6 11

30 50 100 per page

1,659,257

queries

Q&A about the site for scholars and enthusiasts of literature

403 questions

815 answers

3.2k comments

88 tags

jan 24 most recent