Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

2 views

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

oct 15 jon.doe46032
2 views

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

oct 15 jon.doe46032
5 views

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

oct 15
15 views

Duplicate Questions

oct 15
9 views

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

oct 15 jon.doe32071
82 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
10 views

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

oct 15
82 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
82 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
293 views

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

oct 15 jon.doe46027
82 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
293 views

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

oct 15 jon.doe46027
293 views

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

oct 15 jon.doe46027
21 views

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

oct 15
293 views

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

oct 15 jon.doe46027
293 views

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

oct 15 jon.doe46027
22 views

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

oct 15
95 views

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

oct 15 PeterJames
95 views

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

oct 15 PeterJames
23 views

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

oct 15
95 views

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

oct 15 PeterJames
293 views

select * from votes where userid = 442285

oct 15 jon.doe46027
12 views

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

oct 15
23 views

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

oct 15
22 views

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

oct 15
21 views

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

oct 15
293 views

select * from users where id = 442285

oct 15 jon.doe46027
293 views

select top 10 * from votes where userid is not null

oct 15 jon.doe46027
293 views

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

oct 15 jon.doe46027
95 views

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

oct 15 PeterJames
293 views

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

oct 15 jon.doe46027
293 views

select count(1) from votes

oct 15 jon.doe46027
95 views

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

oct 15 PeterJames

30 50 100 per page