Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

1 view

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

oct 15 jon.doe32071
52 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
2 views

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

oct 15
52 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
52 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
217 views

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

oct 15 jon.doe46027
52 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
217 views

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

oct 15 jon.doe46027
217 views

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

oct 15 jon.doe46027
7 views

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

oct 15
217 views

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

oct 15 jon.doe46027
217 views

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

oct 15 jon.doe46027
7 views

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

oct 15
38 views

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

oct 15 PeterJames
38 views

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

oct 15 PeterJames
7 views

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

oct 15
38 views

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

oct 15 PeterJames
217 views

select * from votes where userid = 442285

oct 15 jon.doe46027
5 views

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

oct 15
7 views

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

oct 15
7 views

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

oct 15
7 views

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

oct 15
217 views

select * from users where id = 442285

oct 15 jon.doe46027
217 views

select top 10 * from votes where userid is not null

oct 15 jon.doe46027
217 views

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

oct 15 jon.doe46027
38 views

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

oct 15 PeterJames
217 views

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

oct 15 jon.doe46027
217 views

select count(1) from votes

oct 15 jon.doe46027
38 views

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

oct 15 PeterJames
217 views

select top 100 * from votes

oct 15 jon.doe46027
38 views

select database_id, name from sys.databases

oct 15 PeterJames
217 views

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

oct 15 jon.doe46027
38 views

select * from sys.databases

oct 15 PeterJames

30 50 100 per page