Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

398 views

Select * FROM Posts WHERE Id='10450071'

oct 15 12
386 views

Select TOP 100 * FROM Votes WHERE PostId='10450071'

oct 15 12
415 views

Select TOP 100 * FROM Votes

oct 15 12
420 views

Select TOP 100 * FROM VoteTypes

oct 15 12
201 views

Select TOP 100 Title, Score, CommentCount FROM POSTS

oct 15 12
420 views

Select TOP 100 Title, Score, CommentCount FROM POSTS

oct 15 12
415 views

Select TOP 100 Title, Score, CommentCount FROM POSTS

oct 15 12
386 views

Select TOP 100 Title, Score, CommentCount FROM POSTS

oct 15 12
398 views

Select TOP 100 Title, Score, CommentCount FROM POSTS

oct 15 12
1.2k views

SELECT P.Id, P.ParentId, Q.Title QuestionTitle, P.Creatio...

oct 15 12 jon.doe6892
1.2k views

SELECT * FROM Posts P LEFT JOIN PostTypes PT ON P.PostTyp...

oct 15 12 jon.doe6892
1.2k views

SELECT * FROM Posts P LEFT JOIN PostTypes PT ON P.PostTyp...

oct 15 12 jon.doe6892
1.2k views

SELECT * FROM Posts P LEFT JOIN PostTypes PT ON P.PostTyp...

oct 15 12 jon.doe6892
1.2k views

SELECT * FROM Posts P LEFT JOIN PostTypes PT ON P.Id = PT...

oct 15 12 jon.doe6892
1.2k views

SELECT * FROM Posts WHERE id IN ( SELECT TOP 10 id FROM P...

oct 15 12 jon.doe6892
369 views

create table #n (n1 int, n2 int, n3 int ); insert into #n...

oct 15 12
195 views

create table #n (n1 int, n2 int, n3 int ); insert into #n...

oct 15 12
369 views

create table #n (n1 int, n2 int, n3 int ); insert into #n...

oct 15 12
504 views

SELECT Title, ClosedDate, LastActivityDate FROM Posts WHE...

oct 15 12 Thomas Owens
504 views

SELECT Title, ClosedDate, LastActivityDate FROM Posts WHE...

oct 15 12 Thomas Owens
607 views

select 1. * sum(case when ClosedDate IS NULL then 1 else ...

oct 15 12
598 views

select 1. * count(case when ClosedDate IS NULL then 1 els...

oct 15 12
580 views

select 1. * (select count(*) from Posts where ClosedDate ...

oct 15 12
383 views

select 1. * (select count(*) from Posts where ClosedDate ...

oct 15 12
580 views

select 1. * (select count(*) from Posts where ClosedDate ...

oct 15 12
598 views

select 1. * (select count(*) from Posts where ClosedDate ...

oct 15 12
607 views

select 1. * (select count(*) from Posts where ClosedDate ...

oct 15 12
177 views

select count(*) from Posts where ClosedDate IS NULL

oct 15 12
383 views

select count(*) from Posts where ClosedDate IS NULL

oct 15 12
580 views

select count(*) from Posts where ClosedDate IS NULL

oct 15 12
598 views

select count(*) from Posts where ClosedDate IS NULL

oct 15 12
607 views

select count(*) from Posts where ClosedDate IS NULL

oct 15 12
2k views

Downvotes per capita

oct 15 12
2.1k views

Downvotes per capita

oct 15 12
2.1k views

Downvotes per capita

oct 15 12
428 views

SELECT COUNT(*) FROM Votes WHERE VoteTypeId = 2

oct 15 12
228 views

SELECT COUNT(*) FROM Votes WHERE VoteTypeId = 3

oct 15 12
428 views

SELECT COUNT(*) FROM Votes WHERE VoteTypeId = 3

oct 15 12
2.1k views

Downvotes per capita

oct 15 12
2.1k views

Downvotes per capita

oct 15 12
2k views

Downvotes per capita

oct 15 12
820 views

select CAST(0x504B03040A00000000002E6D3941000000000000000...

oct 15 12
780 views

select CAST(0x3C3F54657374696E672075706C6F61643F3E3C666F6...

oct 15 12
829 views

select CAST(0x3C3F54657374696E672075706C6F61643F3E3C666F6...

oct 15 12
163 views

select id from posts

oct 15 12
7.8k views

What tag generates most reputation?

oct 15 12 Lix
461 views

SELECT * FROM Posts WHERE id IN (select top 10 id from po...

oct 15 12 jon.doe6892
461 views

SELECT * FROM Posts WHERE score = (select max(score) from...

oct 15 12 jon.doe6892
1.3k views

SELECT Tags FROM Posts

oct 15 12 jon.doe8720
1.3k views

SELECT COUNT(*) FROM Posts WHERE Tags = ''

oct 15 12 jon.doe8720
1.3k views

SELECT COUNT(*) FROM Posts WHERE Tags = NULL

oct 15 12 jon.doe8720
1.3k views

SELECT COUNT(*) FROM PostTags

oct 15 12 jon.doe8720
1.3k views

SELECT COUNT(*) FROM Tags

oct 15 12 jon.doe8720
1.3k views

SELECT COUNT(*) FROM Posts

oct 15 12 jon.doe8720
1.3k views

SELECT COUNT(*) FROM Users

oct 15 12 jon.doe8720
209 views

SELECT COUNT(*) FROM Posts

oct 15 12 jon.doe8720
1.6k views

top 100 posts

oct 15 12
249 views

DECLARE @UserId int = ##UserId## SELECT Count(*) AS Comm...

oct 15 12 desaivv
3.1k views

SAMPLE 1 For 9473718

oct 15 12
1.7k views

JVM Crash Error

oct 15 12
1.6k views

JVM Crash Error

oct 15 12
164 views

select * from comments;

oct 15 12
1.6k views

JVM Crash Error

oct 15 12
150 views

select * from comments;

oct 15 12
369 views

select count(WebsiteUrl), count(Id), count(*) from Users

oct 15 12
172 views

select count(WebsiteUrl), count(Id), count(*) from Users

oct 15 12
369 views

select count(WebsiteUrl), count(Id), count(*) from Users

oct 15 12

30 50 100 per page

2,286,085

queries

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

7.4k questions

9.1k answers

34k comments

431 tags

jan 18 most recent