Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

SELECT TOP 10 * FROM Posts LEFT JOIN PostTags ON Posts.Id...

dec 5
0 views

SELECT TOP 10 * FROM Posts LEFT JOIN PostTags ON Posts.Id...

dec 5
0 views

SELECT TOP 10 * FROM Posts LEFT JOIN PostTags ON Posts.Id...

dec 5
0 views

SELECT TOP 10 * FROM Posts LEFT JOIN PostTags ON Posts.Id...

dec 5
0 views

SELECT * FROM PostHistoryTypes

dec 5
0 views

SELECT * FROM PostTags LIMIT

dec 5
1 view

school project

dec 5 jon.doe46150
2 views

SELECT * FROM PostTypes

dec 5
124 views

select * from Posts where Posts.CreationDate > '2024-04-0...

dec 5 leuson
124 views

select * from Posts where Posts.CreationDate > '2024-04-0...

dec 5 leuson
16 views

SELECT * FROM TagSynonyms

dec 5
16 views

SELECT TOP 10 * FROM TagSynonyms

dec 5
15 views

SELECT TOP 10 * FROM Tags

dec 5
14 views

SELECT TOP 10 * FROM PostTags

dec 5
15 views

SELECT TOP 3 * FROM PostTags LEFT JOIN Tags ON PostTags.T...

dec 5
15 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 5
16 views

SELECT TOP 3 * FROM PostTags LEFT JOIN Tags ON PostTags.T...

dec 5
9 views

SELECT TOP 3 * FROM PostTags

dec 5
16 views

SELECT TOP 3 * FROM PostTags

dec 5
15 views

SELECT TOP 3 * FROM PostTags

dec 5
14 views

SELECT TOP 3 * FROM PostTags

dec 5
15 views

SELECT TOP 3 * FROM PostTags

dec 5
16 views

SELECT TOP 3 * FROM PostTags

dec 5
16 views

SELECT TOP 3 * FROM PostTags

dec 5
0 views

SELECT TOP 3 * FROM PostTags

dec 5
0 views

SELECT TOP 3 * FROM PostTags

dec 5
0 views

SELECT TOP 3 * FROM PostTags

dec 5
0 views

SELECT TOP 3 * FROM PostTags

dec 5
10 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 5
15 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 5
59 views

select * from Posts where Posts.CreationDate > '2024-04-0...

dec 5
124 views

select * from Posts where Posts.CreationDate > '2024-04-2...

dec 5 leuson
59 views

select * from Posts where Posts.CreationDate > '2024-04-2...

dec 5 leuson
124 views

select * from Posts where Posts.CreationDate > '2024-04-2...

dec 5 leuson
59 views

select * from Posts where Posts.CreationDate > '2024-04-2...

dec 5 leuson
14 views

SELECT p.Id FROM Posts p WHERE p.PostTypeId = 1 AND EXIST...

dec 5
14 views

SELECT q.Id AS [Question Id], q.Title AS [Question Title]...

dec 5
30 views

SELECT TOP 1 c.userId FROM Comments c WHERE c.userId is n...

dec 5
29 views

SELECT TOP 2 c.userId FROM Comments c WHERE c.userId is n...

dec 5
27 views

SELECT TOP 2 c.userId FROM Comments c WHERE c.userId != n...

dec 5
29 views

SELECT TOP 2 c.userId FROM Comments c GROUP BY c.userId O...

dec 5
124 views

select * from Posts where Posts.CreationDate > '2024-04-0...

dec 5 leuson
59 views

select * from Posts where Posts.CreationDate > '2024-04-0...

dec 5 leuson
124 views

select * from Posts where Posts.CreationDate > '2024-04-0...

dec 5 leuson
59 views

select * from Posts where Posts.CreationDate > '2024-04-0...

dec 5 leuson
124 views

select * from Posts where Posts.CreationDate > '2024-04-1...

dec 5 leuson
59 views

select * from Posts where Posts.CreationDate > '2024-04-1...

dec 5 leuson
30 views

SELECT COUNT(*) FROM Comments c JOIN Posts p ON c.PostId ...

dec 5
32 views

SELECT AVG(AnswerCount) FROM ( SELECT p.Id, COUNT(a.Id) A...

dec 5
29 views

SELECT AVG(AnswerCount) AS AverageAnswersPerQuestion FROM (

dec 5
29 views

SELECT p.Id, COUNT(a.Id) AS AnswerCount FROM Posts p LEFT...

dec 5
29 views

SELECT COUNT(*) AS QuestionCommentsCount FROM Comments c ...

dec 5
28 views

SELECT AVG(AnswerCount) AS AverageAnswersPerQuestion FROM (

dec 5
28 views

SELECT TOP 2 c.userId FROM Comments c GROUP BY c.userId O...

dec 5
29 views

SELECT TOP 1 c.userId FROM Comments c GROUP BY c.userId O...

dec 5
29 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
14 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
29 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
29 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
28 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
28 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
29 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
29 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
29 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
32 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
30 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
29 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
27 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
29 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
30 views

SELECT c.UserId, COUNT(*) AS CommentCount FROM Comments c...

dec 5
30 views

SELECT TOP 50 Title, Body, Tags, Id, Score, ViewCount, Fa...

dec 5 jon.doe46491
30 views

SELECT TOP 50 Title, Body, Tags, Id, Score, ViewCount, Fa...

dec 5 jon.doe46491
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
29 views

Duplicate Questions Count per Month

dec 5
28 views

How many upvotes do I have for each tag?

dec 5
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
6 views

SELECT Users.DisplayName, Users.Id, COUNT(Comments.Id), S...

dec 5
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
824 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 5 jon.doe45585
6 views

SELECT TOP 50 Title, Body, Tags, Id, Score, ViewCount, Fa...

dec 5 jon.doe46491

30 50 100 per page

2,277,394

queries

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

7.3k questions

9.1k answers

33k comments

431 tags

nov 30 most recent