Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

16 views

SELECT se.OwnerUserId as [User Link], p.Id as [Post Link]...

oct 16 PeterJames
16 views

SELECT se.OwnerUserId as [User Link], p.Id as [Post Link]...

oct 16 PeterJames
16 views

SELECT se.OwnerUserId as [User Link], p.Id as [Post Link]...

oct 16 PeterJames
16 views

SELECT se.OwnerUserId as [User Link], p.Id as [Post Link]...

oct 16 PeterJames
16 views

SELECT se.OwnerUserId as [User Link], p.Id as [Post Link]...

oct 16 PeterJames
16 views

SELECT se.OwnerUserId as [User Link], p.Id as [Post Link]...

oct 16 PeterJames
16 views

SELECT se.OwnerUserId, se.* FROM SuggestedEdits se LEFT J...

oct 16 PeterJames
3 views

SELECT se.OwnerUserId FROM SuggestedEdits se LEFT JOIN Po...

oct 16
4 views

SELECT se.OwnerUserId FROM SuggestedEdits se INNER JOIN P...

oct 16
344 views

select * from ( select postid, id, creationdate, row_numb...

oct 16 jon.doe46027
344 views

select * from ( select top 10 postid, id, creationdate, r...

oct 16 jon.doe46027
344 views

select top 10 postid, id, creationdate from comments orde...

oct 16 jon.doe46027
344 views

select top 10 postid, id from comments order by postid, r...

oct 16 jon.doe46027
344 views

select top 10 postid, votetypeid, count(distinct id) c fr...

oct 16 jon.doe46027
344 views

select top 10 id, score from posts where score < 0 order ...

oct 16 jon.doe46027
344 views

select top 100 score from posts where score < 0

oct 16 jon.doe46027
344 views

select top 100 score from posts

oct 16 jon.doe46027
10 views

SELECT tagname, COUNT(*) AS Posts FROM Tags INNER JOIN Po...

oct 16 jon.doe44407
12 views

select * from Posts ORDER BY CreationDate DESC offset 0 r...

oct 16 jon.doe44407
43 views

WITH QuestionAnswers AS ( SELECT q.Id AS QuestionId, q.Ti...

oct 16
34 views

WITH QuestionAnswers AS ( SELECT q.Id AS QuestionId, q.Ti...

oct 16 user27146870
43 views

WITH QuestionAnswers AS ( SELECT q.Id AS QuestionId, q.Ti...

oct 16 user27146870
34 views

WITH QuestionAnswers AS ( SELECT q.Id AS QuestionId, q.Ti...

oct 16 user27146870
43 views

WITH QuestionAnswers AS ( SELECT q.Id AS QuestionId, q.Ti...

oct 16 user27146870
34 views

WITH QuestionAnswers AS ( SELECT q.Id AS QuestionId, q.Ti...

oct 16 user27146870
43 views

WITH QuestionAnswers AS ( SELECT q.Id AS QuestionId, q.Ti...

oct 16 user27146870
10 views

WITH QuestionAnswers AS ( SELECT q.Id AS QuestionId, q.Ti...

oct 15 user27146870
50 views

Looking for some unanswered questions

oct 15
45 views

Looking for some unanswered questions

oct 15
26 views

select id, creationdate from posts where id = 28970

oct 15
26 views

select * from posts where id = 28970

oct 15
24 views

with T as ( select 1 id, 1 pay_type, cast('01.01.2019' as...

oct 15
26 views

with T as ( select 1 id, 1 pay_type, cast('01.01.2019' as...

oct 15
27 views

select top 1 * from posts where id = 28970

oct 15
27 views

select top 1 id from posts where id = 28970

oct 15
25 views

select top 1 id from posts

oct 15
13 views

select * from posts where id = 1

oct 15
25 views

select * from posts where id = 1

oct 15
27 views

select * from posts where id = 1

oct 15
27 views

select * from posts where id = 1

oct 15
26 views

select * from posts where id = 1

oct 15
24 views

select * from posts where id = 1

oct 15
26 views

select * from posts where id = 1

oct 15
26 views

select * from posts where id = 1

oct 15
96 views

SELECT AVG(CAST(Score AS FLOAT)) AS AverageScore, AVG(CAS...

oct 15 Kartik.Mittal45992
96 views

SELECT AVG(CAST(Score AS FLOAT)) AS AverageScore, AVG(CAS...

oct 15 Kartik.Mittal45992
96 views

SELECT AVG(CAST(Score AS FLOAT)) AS AverageScore, AVG(CAS...

oct 15 Kartik.Mittal45992
96 views

SELECT AVG(CAST(Score AS FLOAT)) AS AverageScore, AVG(CAS...

oct 15 Kartik.Mittal45992
96 views

SELECT AVG(CAST(Score AS FLOAT)) AS AverageScore, AVG(CAS...

oct 15 Kartik.Mittal45992
96 views

SELECT AVG(CAST(Score AS FLOAT)) AS AverageScore, AVG(CAS...

oct 15 Kartik.Mittal45992
96 views

SELECT AVG(CAST(Score AS FLOAT)) AS AverageScore, AVG(CAS...

oct 15 Kartik.Mittal45992
96 views

SELECT AVG(CAST(Score AS FLOAT)) AS AverageScore, AVG(CAS...

oct 15 Kartik.Mittal45992
96 views

SELECT AVG(Score) AS AverageScore, AVG(ViewCount) AS Aver...

oct 15 Kartik.Mittal45992
1

135 views

Looking for some unanswered questions

oct 15 async.await
45 views

Looking for some unanswered questions

oct 15 async.await
50 views

Looking for some unanswered questions

oct 15 async.await
34 views

Walk the string

oct 15
34 views

Walk the string

oct 15
1

135 views

Looking for some unanswered questions

oct 15 async.await
45 views

Looking for some unanswered questions

oct 15 async.await
50 views

Looking for some unanswered questions

oct 15 async.await
25 views

SELECT Top 5 Id, CreationDate, AVG(CAST(Score AS FLOAT)) ...

oct 15 jon.doe46032
25 views

SELECT Top 5 Id, CreationDate, AVG(Score) Over() FROM Pos...

oct 15 jon.doe46032
12 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

oct 15
36 views

Duplicate Questions

oct 15
12 views

DECLARE @Period1Start DATE = '2020-11-29'; DECLARE @Perio...

oct 15 jon.doe32071
105 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
12 views

SELECT CONCAT('https://stackoverflow.com/q/', PostId, '#c...

oct 15
105 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
105 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
344 views

select * from ( select top 10 postid, votetypeid, count(d...

oct 15 jon.doe46027
105 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
344 views

select * from ( select top 10 postid from votes where vot...

oct 15 jon.doe46027
344 views

select top 10 postid, votetypeid, count(distinct id) from...

oct 15 jon.doe46027
24 views

select sum(score), owneruserid from posts where commentco...

oct 15
344 views

select top 20 postid, votetypeid, count(distinct id) from...

oct 15 jon.doe46027
344 views

select top 20 postid, votetypeid, count(distinct id) from...

oct 15 jon.doe46027
24 views

select count(*) from posts where score > 1000 and comment...

oct 15
101 views

SELECT 'both', count(*) from stackoverflow.dbo.users u i...

oct 15 PeterJames
101 views

SELECT 'both', count(*) from stackoverflow.dbo.users u l...

oct 15 PeterJames
26 views

Select count(*) from posts where creationdate >= '2024-01...

oct 15
101 views

SELECT count(*) from stackoverflow.dbo.users u left join...

oct 15 PeterJames
344 views

select * from votes where userid = 442285

oct 15 jon.doe46027
13 views

Select count(*) from posts where creationdate >= '2024-01...

oct 15
26 views

Select count(*) from posts where creationdate >= '2024-01...

oct 15
24 views

Select count(*) from posts where creationdate >= '2024-01...

oct 15
24 views

Select count(*) from posts where creationdate >= '2024-01...

oct 15
344 views

select * from users where id = 442285

oct 15 jon.doe46027
344 views

select top 10 * from votes where userid is not null

oct 15 jon.doe46027
344 views

select count(1) from votes where userid is not null and v...

oct 15 jon.doe46027
101 views

SELECT * from stackoverflow.dbo.users where Id = 1859532...

oct 15 PeterJames
344 views

select count(1) from votes where userid is not null

oct 15 jon.doe46027
344 views

select count(1) from votes

oct 15 jon.doe46027
101 views

SELECT * from stackoverflow.dbo.users where Id = 18595321

oct 15 PeterJames
344 views

select top 100 * from votes

oct 15 jon.doe46027
101 views

select database_id, name from sys.databases

oct 15 PeterJames
344 views

select top 100 * from votes where votetypeid in (2,3)

oct 15 jon.doe46027
101 views

select * from sys.databases

oct 15 PeterJames
344 views

select * from votetypes

oct 15 jon.doe46027
101 views

SELECT * from stackoverflow.dbo.users where Id = 18595321

oct 15 PeterJames
101 views

SELECT database_id , name FROM sys.databases

oct 15 PeterJames
101 views

select * from Users where Id = 18595321

oct 15 PeterJames
101 views

select * from Posts where OwnerUserId = 18595321

oct 15 PeterJames
31 views

select TOP 100 * from Posts where Year(CreationDate) = 2024

oct 15 PeterJames
31 views

select * from Posts where OwnerUserId = 18595321

oct 15 PeterJames
31 views

select * from Posts where OwnerUserId = 18595321

oct 15 PeterJames
19 views

Select count(owneruserid) from posts

oct 15
22 views

Select count(commentcount) from posts where creationdate ...

oct 15
24 views

Select sum(score), posttypeid from posts where creationda...

oct 15
23 views

Select sum(score), posttypeid from posts group by posttyp...

oct 15
11 views

Select count(posttypeid), posttypeid from posts group by ...

oct 15
23 views

Select count(posttypeid), posttypeid from posts group by ...

oct 15
24 views

Select count(posttypeid), posttypeid from posts group by ...

oct 15
22 views

Select count(posttypeid), posttypeid from posts group by ...

oct 15
19 views

Select count(posttypeid), posttypeid from posts group by ...

oct 15
14 views

SELECT Id AS [Comment Link], Text FROM Comments WHERE UPP...

oct 15
24 views

SELECT TOP 10 P.*, U.DisplayName FROM POSTS P INNER JOIN ...

oct 15
23 views

SELECT TOP 10 * FROM POSTS P WHERE P.Score < 50

oct 15
12 views

SELECT TOP 10 * FROM POSTS

oct 15
23 views

SELECT TOP 10 * FROM POSTS

oct 15
24 views

SELECT TOP 10 * FROM POSTS

oct 15
1

235 views

Find top editors broken down by edit types

oct 15 PeterJames
283 views

select TOP 500 ph.UserId, ph.UserId as [User Link], u.Dis...

oct 15 PeterJames
4 views

select TOP 500 ph.UserId, ph.UserId as [User Link], u.Dis...

oct 15 PeterJames
3 views

select TOP 500 ph.UserId, ph.UserId as [User Link], u.Dis...

oct 15 PeterJames

30 50 100 per page

2,264,257

queries

Q&A for scientists using computers to solve scientific problems

12k questions

14k answers

55k comments

367 tags

oct 12 most recent