Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

91 views

select PostId as [Post Link],score from Comments where U...

apr 29 11
102 views

select PostId as [Link],score from Comments where UserId...

apr 29 11
98 views

select PostId as [Comment Link],score from Comments where...

apr 29 11
77 views

select ParentId as [Post Link],score from posts where pos...

apr 29 11
91 views

select ParentId as [Post Link],score from posts where pos...

apr 29 11
91 views

select ParentId as [Post Link],score from posts where pos...

apr 29 11
88 views

select ParentId as [Post Link],score from posts where pos...

apr 29 11
82 views

select ParentId, score as [Post Link] from posts where po...

apr 29 11
78 views

select ParentId as [Post Link] from posts where posttypei...

apr 29 11
88 views

select ParentId as [Post Link] from posts where posttypei...

apr 29 11
83 views

select id as [Post Link] from Posts where PostTypeId=1 a...

apr 29 11
146 views

SELECT Id AS [User Link] FROM Users WHERE AboutMe LIKE '%...

apr 29 11 Jimmy Sawczuk
184 views

Quality, not Quantity

apr 29 11 Daniel DiPaolo
153 views

SELECT Id AS [User Link] FROM Users WHERE AboutMe LIKE '...

apr 29 11 Michael Mrozek
102 views

SELECT Id AS [User Link] FROM Users WHERE AboutMe LIKE '%...

apr 29 11 Michael Mrozek
99 views

SELECT Id AS [User Link] FROM Users WHERE AboutMe LIKE '%...

apr 29 11 Michael Mrozek
99 views

SELECT Id AS [User Link] FROM Users WHERE DisplayName LIK...

apr 29 11 Michael Mrozek
130 views

SELECT Id AS [User Link] FROM Users WHERE DisplayName LIK...

apr 29 11 Michael Mrozek
118 views

SELECT Id AS [User Link] FROM Users WHERE DisplayName LIK...

apr 29 11 Michael Mrozek
131 views

SELECT Id AS [User Link] FROM Users WHERE DisplayName LIK...

apr 29 11 Michael Mrozek
208 views

Top Askers Last 30 Days (with score)

apr 29 11 Adam Davis
98 views

Popular Questions without Nice Answers

apr 29 11
89 views

Popular Questions without Nice Answers

apr 29 11
117 views

Popular Questions without Nice Answers

apr 29 11
163 views

Top Askers Last 30 Days (with score)

apr 29 11 Adam Davis
108 views

SELECT Score, COUNT(*) FROM Posts WHERE OwnerUserId = 39...

apr 29 11
131 views

SELECT Score, COUNT(*) FROM Posts WHERE OwnerUserId = 39...

apr 29 11
96 views

Popular Questions without Nice Answers

apr 29 11
92 views

SELECT COUNT(*) FROM Posts WHERE OwnerUserId = 39677 GRO...

apr 29 11
88 views

SELECT COUNT(*) FROM Posts WHERE OwnerUserId = 39677 AND...

apr 29 11
106 views

Popular Questions without Nice Answers

apr 29 11
100 views

select * from comments where UserId = 473070 and Score > 4;

apr 29 11
107 views

Popular Questions without Nice Answers

apr 29 11
84 views

select count(*) from comments where UserId = 473070 and S...

apr 29 11
100 views

Popular Questions without Nice Answers

apr 29 11
102 views

select count(*) from comments where UserId = 473070;

apr 29 11
96 views

Popular Questions without Nice Answers

apr 29 11
84 views

select count(*) from posts where LastEditorUserId = 473070;

apr 29 11
104 views

Foo

apr 29 11
136 views

select distinct TagName from Tags

apr 29 11
117 views

SELECT TOP 20 Posts.Title, Comments.Text, Comments.Score,...

apr 29 11 teddy.puleva
135 views

SELECT TOP 20 Posts.Title, Comments.Text, Comments.Score,...

apr 29 11 teddy.puleva
119 views

SELECT TOP 20 Posts.Title, Comments.Text, Comments.Score,...

apr 29 11 teddy.puleva
127 views

select * from posthistorytypes -- where userid > 327771

apr 29 11 teddy.puleva
97 views

select * from votetypes-- where userid > 327771

apr 29 11 teddy.puleva
111 views

select * from votes-- where userid > 327771

apr 29 11 teddy.puleva
92 views

select min(creationdate) from comments -- where userid > ...

apr 29 11 teddy.puleva
86 views

select * from comments where userid > 327771

apr 29 11 teddy.puleva
122 views

select * from comments where userid > 320000 --7771

apr 29 11 teddy.puleva
90 views

select * from comments --where userid = 327771

apr 29 11 teddy.puleva
70 views

select * from comments where userid = 327771

apr 29 11 teddy.puleva
95 views

select * from comments where userid = '327771'

apr 29 11 teddy.puleva
112 views

View Amortization

apr 29 11 martin clayton
107 views

select title from posts where owneruserid = 40396

apr 29 11 jon.doe5765
107 views

select id from users where displayname = 'betitall'

apr 29 11 jon.doe5765
151 views

select id from users where displayname = 'jon.doe5765'

apr 29 11 jon.doe5765
155 views

select id from users where displayname = 'ASPiringdev'

apr 29 11
105 views

select id, owneruserid from posts where ownerdisplayname ...

apr 29 11
127 views

SELECT CONVERT( VARCHAR(6), p.CreationDate, 112 ) + '01'...

apr 29 11 martin clayton
108 views

select id, owneruserid from posts where ownerdisplayname ...

apr 29 11
127 views

select id, owneruserid from posts where id < 100

apr 29 11
115 views

select top 100 displayName, count(1) from users u lef...

apr 29 11
106 views

select top 100 displayName, count(*) from users u lef...

apr 29 11
141 views

SELECT CONVERT( VARCHAR(6), p.CreationDate, 112 ) + '01'...

apr 29 11 martin clayton
99 views

SELECT CONVERT( VARCHAR(6), p.CreationDate, 112 ) + '01'...

apr 29 11 martin clayton
97 views

select top 100 displayName, reputation from users orde...

apr 29 11
96 views

select top 100 displayName, reputation from users orde...

apr 29 11
122 views

select top 100 displayName, reputation from users

apr 29 11
107 views

SELECT CONVERT( VARCHAR(6), p.CreationDate, 112 ) AS Month

apr 29 11 martin clayton
117 views

SELECT CONVERT( VARCHAR(6), p.CreationDate, 112 ) AS Month

apr 29 11 martin clayton
124 views

SELECT CONVERT( VARCHAR(6), p.CreationDate, 112 ) , AVG(...

apr 29 11 martin clayton
102 views

SELECT CONVERT( VARCHAR(6), p.CreationDate, 112 ) , AVG(...

apr 29 11 martin clayton
133 views

Testing

apr 28 11 this.josh
151 views

Testing

apr 28 11 this.josh
129 views

Testing

apr 28 11 this.josh
126 views

Testing

apr 28 11 this.josh
154 views

Testing

apr 28 11 this.josh
148 views

Testing

apr 28 11 this.josh
119 views

Testing

apr 28 11 this.josh
149 views

Testing

apr 28 11 this.josh
110 views

Testing

apr 28 11 this.josh
166 views

Testing

apr 28 11 this.josh
142 views

Testing

apr 28 11 this.josh
132 views

Testing

apr 28 11 this.josh
140 views

Testing

apr 28 11 this.josh
156 views

SELECT COUNT(*) FROM Users WHERE Reputation < 10 AND (SEL...

apr 28 11 this.josh
165 views

Time of day

apr 28 11 bcs1
152 views

Time of day

apr 28 11 bcs1
141 views

User Statistics

apr 28 11 Jimmy Sawczuk
617 views

User Statistics

apr 28 11 Jimmy Sawczuk
307 views

User Statistics

apr 28 11 Jimmy Sawczuk
112 views

SELECT COUNT(*) FROM Users WHERE Reputation < 10 AND (SEL...

apr 28 11 this.josh
135 views

SELECT COUNT(*) FROM Users WHERE Reputation < 10 AND (SEL...

apr 28 11 this.josh
132 views

SELECT Id FROM Users WHERE Reputation < 10 AND (SELECT CO...

apr 28 11 this.josh
136 views

SELECT Id AS [User Link] FROM Users WHERE Reputation < 1...

apr 28 11 this.josh
132 views

SELECT Id AS [User Link] FROM Users WHERE Reputation < 10...

apr 28 11 this.josh
107 views

SELECT Id AS [User Link] FROM Users WHERE Reputation > 30...

apr 28 11 this.josh
104 views

SELECT Id AS [User Link], (SELECT COUNT(*) FROM Posts WHE...

apr 28 11 this.josh
124 views

SELECT Id AS [User Link], (SELECT COUNT(*) FROM Posts WHE...

apr 28 11 this.josh
150 views

SELECT Id AS [User Link], (SELECT COUNT(*) FROM Posts WHE...

apr 28 11 this.josh
157 views

SELECT Id AS [User Link], (SELECT COUNT(*) FROM Posts WHE...

apr 28 11 this.josh
111 views

SELECT Id AS [User Link], (SELECT COUNT(*) FROM Posts WHE...

apr 28 11 this.josh

30 50 100 per page

1,659,263

queries

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

23k questions

34k answers

86k comments

339 tags

jan 24 most recent