Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

164 views

WITH posts_with_votes(ID) AS ( SELECT p.ID FROM Posts p ...

jan 21 11
175 views

WITH posts_with_votes(ID) AS ( SELECT p.ID FROM Posts p ...

jan 21 11
146 views

WITH posts_with_votes(ID) AS ( SELECT p.ID FROM Posts p ...

jan 21 11
165 views

SELECT COUNT(*) FROM Posts p JOIN Posts aa ON aa.ParentI...

jan 21 11
178 views

SELECT p.ID FROM Posts p JOIN Posts aa ON aa.ParentId = ...

jan 21 11
175 views

SELECT p.ID, COUNT(*) FROM Posts p JOIN Posts aa ON aa.P...

jan 21 11
157 views

SELECT TOP 100 p.ID, COUNT(*) FROM Posts p JOIN Posts a...

jan 21 11
136 views

SELECT TOP 100 p.ID, COUNT(*) FROM Posts p JOIN Posts a...

jan 21 11
192 views

SELECT TOP 100 p.ID, COUNT(*) FROM Posts p JOIN Posts aa...

jan 21 11
166 views

SELECT TOP 1 p.ID, COUNT(*) FROM Posts p JOIN Posts aa O...

jan 21 11
123 views

SELECT p.ID, COUNT(*) FROM Posts p JOIN Posts aa ON aa.P...

jan 21 11
113 views

Shows all users in Melb

jan 21 11
131 views

WITH count_accepted (Id, AcceptCount) AS ( SELECT p.ID, ...

jan 21 11
144 views

WITH count_accepted (Id, AcceptCount) AS ( SELECT p.ID, ...

jan 21 11
143 views

WITH count_accepted (Id, AcceptCount) AS ( SELECT p.ID, ...

jan 21 11
131 views

Shows all users in Melb

jan 21 11
133 views

select * from users where Location = 'Melbourne'

jan 21 11
147 views

select count(*) from posts q where posttypeid = 1 and ex...

jan 21 11
142 views

select count(*) from posts q where posttypeid = 1

jan 21 11
121 views

select count(*) from posts q where posttypeid = 1 and ex...

jan 21 11
134 views

select count(*) from posts q where posttypeid = 1 and ex...

jan 21 11
94 views

SELECT COUNT(*) FROM Posts WHERE PostTypeId IN (2, 3)

jan 20 11
122 views

SELECT COUNT(*) FROM Posts WHERE PostTypeId = 2

jan 20 11
115 views

SELECT COUNT(*) FROM Posts WHERE AnswerCount >= 1 AND P...

jan 20 11
145 views

SELECT COUNT(*) FROM Posts WHERE AcceptedAnswerId IS NO...

jan 20 11
163 views

SELECT COUNT(*) FROM Posts WHERE PostTypeId = 1

jan 20 11
128 views

SELECT * FROM PostTypes

jan 20 11
138 views

SELECT COUNT(*) FROM Posts

jan 20 11
141 views

SELECT COUNT(*) FROM Posts SELECT COUNT(*) FROM Posts WH...

jan 20 11
106 views

SELECT COUNT(*) FROM Posts SELECT COUNT(*) FROM Posts WH...

jan 20 11
134 views

select * from posts WHERE 1=1 AND ParentId IS NULL AND Ac...

jan 20 11 rodrigo.ruz.v
126 views

select * from posts WHERE 1=1 AND ParentId IS NULL AND Ac...

jan 20 11 rodrigo.ruz.v
120 views

select * from posts WHERE 1=1 AND ParentId IS NULL AND Ac...

jan 20 11 rodrigo.ruz.v
131 views

select count(*) from posts WHERE 1=1 AND ParentId IS NULL...

jan 20 11 rodrigo.ruz.v
116 views

select top 100 * from posts WHERE 1=1 AND ParentId IS NUL...

jan 20 11 rodrigo.ruz.v
143 views

select * from posts WHERE 1=1 AND ParentId IS NULL AND UP...

jan 20 11 rodrigo.ruz.v
128 views

select top 10 * from posts WHERE 1=1 AND ParentId IS NULL...

jan 20 11 rodrigo.ruz.v
165 views

select top 10 * from posts WHERE 1=1 AND UPPER(Body) like...

jan 20 11 rodrigo.ruz.v
126 views

select top 5 * from posts WHERE 1=1 AND Body like '%delph...

jan 20 11 rodrigo.ruz.v
157 views

select top 5 * from posts WHERE 1=1 AND Body like '%delph...

jan 20 11 rodrigo.ruz.v
163 views

select top 5 * from posts WHERE 1=1 AND Body like '%delph...

jan 20 11 rodrigo.ruz.v
144 views

select top 5 * from posts WHERE 1=1 AND Body like '%delph...

jan 20 11 rodrigo.ruz.v
126 views

select top 10 id from posts WHERE 1=1 AND UPPER(Body) lik...

jan 20 11 rodrigo.ruz.v
117 views

select id from posts WHERE 1=1 AND UPPER(Body) like '%DEL...

jan 20 11 rodrigo.ruz.v
102 views

select * from posts WHERE 1=1 AND UPPER(Body) like '%DELP...

jan 20 11 rodrigo.ruz.v
102 views

select top 1000 tags from posts

jan 20 11 rodrigo.ruz.v
96 views

select * from Users

jan 20 11
97 views

select row_number() over(order by Reputation desc) as Ran...

jan 20 11
90 views

select row_number() over(order by Reputation desc) as Ran...

jan 20 11
102 views

select row_number() over(order by Reputation desc) as Ran...

jan 20 11
238 views

Problem Users

jan 20 11 sam.saffron
113 views

Problem Users

jan 20 11 sam.saffron
127 views

Problem Users

jan 20 11 sam.saffron
111 views

select top 100 * from Votes where VoteTypeId = 3

jan 20 11 sam.saffron
107 views

Problem Users

jan 20 11 sam.saffron
120 views

Problem Users

jan 20 11 sam.saffron
170 views

Problem Users

jan 20 11
98 views

Keystrokes per rep point

jan 20 11
132 views

Keystrokes per rep point

jan 20 11
121 views

Keystrokes per rep point

jan 20 11
122 views

Keystrokes per rep point

jan 20 11
88 views

Keystrokes per rep point

jan 20 11
109 views

Keystrokes per rep point

jan 20 11
118 views

create table #TotalVotes(UserId int, Upvotes int, Downvot...

jan 20 11
120 views

select top 10 ViewCount from posts order by Viewcount desc

jan 20 11
160 views

select top 10 ViewCount from posts order by Viewcount

jan 20 11
121 views

select postid from posthistory where posthistorytypeid =...

jan 20 11
111 views

select * from posthistory where posthistorytypeid = 10 a...

jan 20 11
178 views

SELECT TOP 100 Users.Id AS [User Link], (SELECT Count(*) ...

jan 20 11
179 views

Electorate Badge progress

jan 20 11 tnarrosf
150 views

Electorate Badge progress

jan 20 11 tnarrosf
183 views

Electorate Badge progress

jan 20 11 tnarrosf
137 views

Select * from PostTypes

jan 20 11 tnarrosf
151 views

Electorate Badge progress

jan 20 11 tnarrosf
153 views

Electorate Badge progress

jan 20 11 tnarrosf
136 views

Order users by accepted ratio

jan 20 11 martin clayton
102 views

select * from Posts where PostTypeId =1 and Id= 26762

jan 20 11
111 views

SELECT COUNT(*) FROM Posts WHERE Score > 1 AND PostTypeId...

jan 20 11
92 views

SELECT COUNT(*) FROM Posts WHERE Score > 1 AND PostTypeId...

jan 20 11
96 views

SELECT COUNT(*) FROM Posts WHERE Score > 1 AND PostTypeId...

jan 20 11
107 views

SELECT COUNT(*) FROM Posts WHERE Score > 1 AND PostTypeId...

jan 20 11
118 views

SELECT COUNT(*) FROM Posts WHERE Score > 1 AND PostTypeId...

jan 20 11
117 views

SELECT COUNT(*) FROM Posts WHERE PostTypeId = 1 AND 1 = 1

jan 20 11
138 views

SELECT COUNT(*) FROM Posts WHERE Score > 0 AND PostTypeId...

jan 20 11
128 views

SELECT COUNT(*) FROM Posts WHERE Score > 1 AND PostTypeId...

jan 20 11
132 views

SELECT COUNT(*) FROM Posts WHERE Score > 1 AND PostTypeId...

jan 20 11
121 views

SELECT COUNT(*) FROM Posts WHERE Score > 0 AND CreationDa...

jan 20 11
115 views

SELECT COUNT(*) FROM Posts WHERE Score > 2 AND CreationDa...

jan 20 11
117 views

SELECT COUNT(*) FROM Posts WHERE Score > 1 AND CreationDa...

jan 20 11
123 views

WITH post_counts (yr, mth, cnt) AS ( SELECT Year(Creation...

jan 20 11
104 views

WITH post_counts (yr, mth, cnt) AS ( SELECT Year(Creation...

jan 20 11
108 views

WITH post_counts (yr, mth, cnt) AS ( SELECT Year(Creation...

jan 20 11
115 views

WITH post_counts (yr, mth, cnt) AS ( SELECT Year(Creation...

jan 20 11
108 views

WITH post_counts (yr, mth, cnt) AS ( SELECT Year(Creation...

jan 20 11
100 views

WITH post_counts (yr, mth, cnt) AS ( SELECT Year(Creation...

jan 20 11
132 views

WITH post_counts (yr, mth, cnt) AS ( SELECT Year(Creation...

jan 20 11
131 views

SELECT TOP 1 * FROM Posts ORDER BY Id DESC

jan 20 11
116 views

WITH post_counts (yr, mth, cnt) AS ( SELECT Year(Creation...

jan 20 11
98 views

WITH post_counts (yr, mth, cnt) AS ( SELECT Year(Creation...

jan 20 11
93 views

WITH post_counts (yr, mth, cnt) AS ( SELECT Year(Creation...

jan 20 11

30 50 100 per page

1,680,064

queries

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

58 questions

126 answers

217 comments

81 tags

feb 28 most recent