Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

1 view

SELECT FORMAT(CreationDate, 'yyyy-MM') AS year_month, Pos...

sep 19
1 view

SELECT FORMAT(CreationDate, 'yyyy-MM') AS year_month, Pos...

sep 19
1 view

SELECT FORMAT(CreationDate, 'yyyy-MM') AS year_month, Pos...

sep 19
3 views

SELECT FORMAT(CreationDate, 'yyyy-MM') AS year_month, COU...

sep 19
173 views

HW2

sep 19 jon.doe45740
3 views

SELECT DISTINCT COUNT(*) as num_of_posts, MIN(CreationDat...

sep 19
3 views

SELECT DISTINCT COUNT(*) as num_of_posts, MIN(CreationDat...

sep 19
173 views

HW2

sep 19 jon.doe45740
3 views

SELECT DISTINCT COUNT(*) as num_of_posts, MIN(CreationDat...

sep 19
3 views

SELECT DISTINCT COUNT(*) as num_of_posts, MIN(CreationDat...

sep 19
173 views

HW2

sep 19 jon.doe45740
173 views

HW2

sep 19 jon.doe45740
173 views

HW2

sep 19 jon.doe45740
3 views

SELECT DISTINCT COUNT(*) as num_of_posts, MIN(CreationDat...

sep 19
173 views

HW2

sep 19 jon.doe45740
173 views

HW2

sep 19 jon.doe45740
3 views

SELECT DISTINCT COUNT(*) as num_of_posts, MIN(CreationDat...

sep 19
3 views

SELECT DISTINCT COUNT(*) as num_of_posts, MIN(CreationDat...

sep 19
3 views

SELECT DISTINCT COUNT(*) as num_of_posts, MIN(CreationDat...

sep 19
173 views

HW2

sep 19 jon.doe45740
7 views

WITH CommentCounts AS ( SELECT c.UserId AS CommentorId, C...

sep 19
7 views

WITH CommentData AS ( SELECT c.Id AS CommentId, c.PostId ...

sep 19
13 views

Most upvoted comments on your questions and answers

sep 19
173 views

HW2

sep 19 jon.doe45740
173 views

HW2

sep 19 jon.doe45740
7 views

SELECT DISTINCT c.Id AS CommentId, c.PostId AS AnswerId, ...

sep 19
8 views

SELECT DISTINCT c.Id AS CommentId, c.PostId AS AnswerId, ...

sep 19
8 views

SELECT DISTINCT c.Id AS CommentId, c.PostId AS AnswerId, ...

sep 19
8 views

SELECT DISTINCT c.Id AS CommentId, c.PostId AS AnswerId, ...

sep 19
8 views

SELECT DISTINCT c.Id AS CommentId, c.PostId, c.CreationDa...

sep 19
8 views

SELECT DISTINCT c.Id AS CommentId, c.PostId AS AnswerId, ...

sep 19
9 views

SELECT DISTINCT c.Id AS CommentId, c.PostId AS AnswerId, ...

sep 19
8 views

SELECT DISTINCT c.Id AS CommentId, c.PostId AS AnswerId, ...

sep 19
9 views

SELECT DISTINCT c.Id AS CommentId, c.PostId AS AnswerId, ...

sep 19
9 views

SELECT DISTINCT c.Id AS CommentId, c.PostId, c.CreationDa...

sep 19
9 views

SELECT DISTINCT c.Id AS CommentId, c.PostId, c.CreationDa...

sep 19
9 views

SELECT Id, DIsplayName, Location FROM Users WHERE Locatio...

sep 19
9 views

SELECT DISTINCT c.Id AS CommentId, c.PostId, c.CreationDa...

sep 19
8 views

SELECT DISTINCT c.Id AS CommentId, c.PostId, c.CreationDa...

sep 19
173 views

HW2

sep 19 jon.doe45740
9 views

SELECT COUNT(*) FROM Users WHERE Location LIKE '%NY%' OR ...

sep 19
9 views

SELECT DISTINCT c.Id AS CommentId, c.PostId, c.CreationDa...

sep 19
173 views

HW2

sep 19 jon.doe45740
9 views

SELECT * FROM Users WHERE Location LIKE '%New York%';

sep 19
9 views

SELECT COUNT(*) FROM Users WHERE Location LIKE '%NY%' OR ...

sep 19
9 views

SELECT COUNT(*) FROM Users WHERE Location LIKE '%NY%';

sep 19
9 views

SELECT * FROM Users WHERE Location LIKE '%NY%';

sep 19
173 views

HW2

sep 19 jon.doe45740
173 views

HW2

sep 19 jon.doe45740
9 views

SELECT c.PostId, c.CreationDate AS CommentDate, c.Text, v...

sep 19

30 50 100 per page

2,252,587

queries

Q&A about the site for legal professionals, students, and others with experience or interest in law

637 questions

1.1k answers

2.5k comments

90 tags

sep 13 most recent