Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

101 views

select top 250 Id as [User Link], Reputation as rep, UpV...

may 29 11 sblair
114 views

select top 100 Id as [User Link], Reputation as rep, UpV...

may 29 11 sblair
96 views

select top 50 Id as [User Link], Reputation as rep, UpVo...

may 29 11 sblair
135 views

select top 10 Id as [User Link], Reputation as rep, UpVo...

may 29 11 sblair
105 views

select top 10 Id as [User Link], Reputation as rep, UpVo...

may 29 11 sblair
109 views

select top 10 Id as [User Link], Reputation as rep, UpVo...

may 29 11 sblair
166 views

select top 10 Id as [user], Reputation as rep, UpVotes a...

may 29 11 sblair
138 views

select top 10 Id as [User], Reputation as rep, UpVotes a...

may 29 11 sblair
118 views

select top 10 Id as [UserID], Reputation as rep, UpVotes...

may 29 11 sblair
92 views

select top 10 Id as UserID, Reputation as rep, UpVotes a...

may 29 11 sblair
110 views

select top 10 Id as UserID, Reputation as rep, UpVotes a...

may 29 11 sblair
109 views

select top 10 Id as UserID, UpVotes as u, DownVotes as d...

may 29 11 sblair
117 views

select top 10 Id as UserID, UpVotes as u, DownVotes as d...

may 29 11 sblair
99 views

select top 10 Id as UserID, UpVotes as u, DownVotes as d...

may 29 11 sblair
135 views

select top 10 Id as UserID, UpVotes, DownVotes, cast(Rep...

may 29 11 sblair
152 views

select top 10 Id as UserID, UpVotes, DownVotes, cast(Rep...

may 29 11 sblair
117 views

select top 10 Id as UserID, cast(Reputation as numeric) ...

may 29 11 sblair
100 views

select top 1000 Id as UserID, cast(Reputation as numeric...

may 29 11 sblair
118 views

select Id as UserID, cast(Reputation as numeric) as rati...

may 29 11 sblair
382 views

Relational division with xquery

may 29 11 Mikael Eriksson
674 views

Relational division with xquery

may 29 11 Mikael Eriksson
465 views

Relational division with xquery

may 29 11 Mikael Eriksson
319 views

Relational division with xquery

may 29 11 Mikael Eriksson
331 views

Relational division with xquery

may 29 11 Mikael Eriksson
382 views

Relational division with xquery

may 29 11 Mikael Eriksson
354 views

Relational division with xquery

may 29 11 Mikael Eriksson
342 views

Relational division with xquery

may 29 11 Mikael Eriksson
342 views

Relational division with xquery

may 29 11 Mikael Eriksson
386 views

Relational division with xquery

may 29 11 Mikael Eriksson
322 views

Relational division with xquery

may 29 11 Mikael Eriksson
344 views

Relational division with xquery

may 29 11 Mikael Eriksson
381 views

Relational division with xquery

may 29 11 Mikael Eriksson
385 views

Relational division with xquery

may 29 11 Mikael Eriksson
403 views

Relational division with xquery

may 29 11 Mikael Eriksson
380 views

Relational division with xquery

may 29 11 Mikael Eriksson
167 views

Relational division with xquery

may 29 11 Mikael Eriksson
213 views

Relational division with xquery

may 29 11 Mikael Eriksson
105 views

select y,m,count(*) c from ( SELECT Year(CreationDate) y,...

may 29 11 Randall.Vernes
96 views

select d,count(*) from ( SELECT Year(CreationDate) * 100+...

may 29 11
69 views

select d,count(*) from ( SELECT Year(CreationDate) * 100+...

may 29 11
102 views

select d,count(*) from ( SELECT TOP 20 Year(CreationDate)...

may 29 11
81 views

SELECT TOP 20 Year(CreationDate) * 100+ Month(CreationDat...

may 29 11
78 views

SELECT TOP 20 Year(CreationDate) * 10000+ Month(CreationD...

may 29 11
68 views

SELECT TOP 100 Year(CreationDate) + '-' + Month(CreationD...

may 29 11
75 views

SELECT TOP 100 Year(CreationDate) as y, Month(CreationDat...

may 29 11
70 views

SELECT TOP 100 Year(CreationDate) as y, Month(CreationDat...

may 29 11
63 views

SELECT TOP 100 Year(CreationDate) FROM Users ORDER BY Cr...

may 29 11
74 views

SELECT TOP 100 CreationDate FROM Users ORDER BY Creation...

may 29 11
66 views

select * from posts order by creationDate asc

may 29 11
58 views

select count(id) from posts where PostTypeId = 2

may 29 11
58 views

select count(id) from posts where PostTypeId = 1

may 29 11
74 views

select max(id) from posts where PostTypeId = 1

may 29 11
71 views

select max(id) from posts where PostTypeId = 2

may 29 11
70 views

select max(id) from posts where postTypeId = 2

may 29 11
67 views

select max(id) from posts where postTypeId = 1

may 29 11
77 views

select id from posts where PostTypeId=1

may 29 11
69 views

select max(id) from posts where PostTypeId=1

may 29 11
64 views

select count(*) from posts where PostTypeId=1

may 29 11
61 views

select count(*) from posts where PostTypeId=2

may 29 11
89 views

Premature optimization in comments

may 29 11
98 views

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

may 29 11 Rebecca Chernoff
123 views

SELECT u.Id, u.DisplayName, COUNT(*) AS '# Posts' FROM P...

may 29 11 Rebecca Chernoff
101 views

SELECT u.Id, u.DisplayName, COUNT(*) AS '# Posts' FROM P...

may 29 11 Rebecca Chernoff
2.3k views

Enter Query Title

may 29 11 Rebecca Chernoff
96 views

SELECT u.Id, u.DisplayName, COUNT(*) AS '# Posts' FROM P...

may 29 11 Rebecca Chernoff
88 views

select Id as [User Link], Reputation, AboutMe from Users ...

may 29 11
60 views

select Id as [User Link], Reputation, AboutMe from Users ...

may 29 11
76 views

select Id as [User Link], Reputation, AboutMe from Users ...

may 29 11
89 views

select Id as [User Link], Reputation, AboutMe from Users ...

may 29 11
145 views

Keystrokes per rep point

may 29 11 jjnguy
198 views

declare @UserId int = ##UserId##; select p.Id [Post Lin...

may 28 11 marat.snowbear
162 views

declare @UserId int = ##UserId##; select distinct p.Id ...

may 28 11 marat.snowbear
156 views

declare @UserId int = ##UserId##; select p.Id [Post Lin...

may 28 11 marat.snowbear
4

9k views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
632 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
878 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
960 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
979 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
2

2.1k views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
1k views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
939 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
995 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
2

2.6k views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
1

994 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
317 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
322 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
292 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
358 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
339 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
368 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
370 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
325 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
440 views

'Copy editor' and 'Strunk & White' badges progress

may 28 11 marat.snowbear
143 views

declare @UserId int = ##UserId##; select p.Id [Post Lin...

may 28 11 marat.snowbear
166 views

declare @UserId int = ##UserId##; select p.Id [Post Id]...

may 28 11 marat.snowbear
188 views

declare @UserId int = ##UserId##; select p.Id [Post] fr...

may 28 11 marat.snowbear
139 views

declare @UserId int = ##UserId##; select p.Id [PostId] ...

may 28 11 marat.snowbear
165 views

declare @UserId int = ##UserId##; select * from PostHis...

may 28 11 marat.snowbear
148 views

declare @UserId int = ##UserId##; select * from PostHis...

may 28 11 marat.snowbear
133 views

declare @UserId int = ##UserId##; select * from PostHis...

may 28 11 marat.snowbear
95 views

SELECT TOP 20 Title, Body, ViewCount, Tags FROM Posts WHE...

may 28 11
92 views

SELECT TOP 10 Title, Body, ViewCount, Tags FROM Posts WHE...

may 28 11
82 views

SELECT TOP 10 Title, Body, ViewCount, Tags FROM Posts WHE...

may 28 11
112 views

SELECT TOP 10 Title, Body, ViewCount, Tags FROM Posts ORD...

may 28 11
106 views

SELECT Q.OwnerUserId, Q.OwnerDisplayName, Q.Title, A.Owne...

may 28 11
103 views

SELECT Q.OwnerUserId, Q.OwnerDisplayName, Q.Title, A.Owne...

may 28 11
99 views

SELECT Q.OwnerUserId, Q.OwnerDisplayName, Q.Title, A.Owne...

may 28 11
82 views

SELECT Q.OwnerUserId, Q.OwnerDisplayName, Q.Title, A.Owne...

may 28 11
90 views

SELECT Q.OwnerUserId, Q.OwnerDisplayName, Q.Title, A.Owne...

may 28 11
105 views

SELECT Q.OwnerUserId, Q.OwnerDisplayName, Q.Title, A.Owne...

may 28 11
118 views

SELECT Q.OwnerUserId,Q.Title, A.OwnerUserId, A.Title FROM...

may 28 11
107 views

SELECT Q.OwnerUserId, A.OwnerUserId FROM Posts Q, Posts A...

may 28 11
92 views

SELECT Q.OwnerUserId, A.OwnerUserId from Posts Q, Posts A

may 28 11
134 views

SELECT TOP ##QueryLimit## Users.Id as [User Link], Users....

may 28 11 Robik
159 views

SELECT TOP ##QueryLimit## Users.Id as [User Link], Users....

may 28 11 Robik
135 views

SELECT TOP ##QueryLimit## Users.Id as [User Line], Users....

may 28 11 Robik
157 views

SELECT TOP ##QueryLimit## Users.Id as [UserID], Users.Dis...

may 28 11 Robik
139 views

SELECT TOP ##QueryLimit## Users.Id as [UserID], Users.Dis...

may 28 11 Robik
148 views

SELECT TOP ##QueryLimit## Users.Id as [UserID], Users.Dis...

may 28 11 Robik
197 views

SELECT TOP ##QueryLimit## Users.Id as [UserID], Users.Dis...

may 28 11 Robik
105 views

TOP 50 users from INDIA

may 28 11
110 views

TOP 50 users from INDIA

may 28 11
131 views

TOP 50 users from INDIA

may 28 11
167 views

SELECT TOP ##QueryLimit## Users.DisplayName as [User], Us...

may 28 11 Robik
147 views

SELECT TOP ##QueryLimit## Users.DisplayName as [User], Us...

may 28 11
130 views

SELECT TOP ##Limit## Users.DisplayName as [User], Users.A...

may 28 11
122 views

SELECT TOP 10 Users.DisplayName as [User], Users.Age as [...

may 28 11
127 views

select Users.DisplayName as [User], Users.Age as [Age] from

may 28 11
123 views

select Users.DisplayName as [User], Users.Age as [Age] from

may 28 11
108 views

select Users.DisplayName as [User], Users.Age as [Age] from

may 28 11
121 views

Find the greatest Necromancers on SO

may 28 11
98 views

Find the greatest Necromancers on SO

may 28 11
146 views

My highest quality answers

may 27 11 Fredrik Mörk
143 views

My highest quality answers

may 27 11 Fredrik Mörk
151 views

My highest quality answers

may 27 11 Fredrik Mörk
155 views

My highest quality answers

may 27 11 Fredrik Mörk

30 50 100 per page

1,370,042

queries

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

11k questions

27k answers

87k comments

990 tags

oct 13 most recent