Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

4 views

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

oct 15
13 views

Duplicate Questions

oct 15
8 views

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

oct 15 jon.doe32071
78 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
9 views

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

oct 15
78 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
78 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
285 views

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

oct 15 jon.doe46027
78 views

# of active users prior to and after chatgpt

oct 15 jon.doe32071
285 views

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

oct 15 jon.doe46027
285 views

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

oct 15 jon.doe46027
19 views

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

oct 15
285 views

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

oct 15 jon.doe46027
285 views

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

oct 15 jon.doe46027
21 views

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

oct 15
89 views

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

oct 15 PeterJames
89 views

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

oct 15 PeterJames
21 views

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

oct 15
89 views

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

oct 15 PeterJames
285 views

select * from votes where userid = 442285

oct 15 jon.doe46027
11 views

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

oct 15
21 views

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

oct 15
21 views

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

oct 15
19 views

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

oct 15
285 views

select * from users where id = 442285

oct 15 jon.doe46027
285 views

select top 10 * from votes where userid is not null

oct 15 jon.doe46027
285 views

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

oct 15 jon.doe46027
89 views

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

oct 15 PeterJames
285 views

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

oct 15 jon.doe46027
285 views

select count(1) from votes

oct 15 jon.doe46027
89 views

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

oct 15 PeterJames
285 views

select top 100 * from votes

oct 15 jon.doe46027
89 views

select database_id, name from sys.databases

oct 15 PeterJames
285 views

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

oct 15 jon.doe46027
89 views

select * from sys.databases

oct 15 PeterJames
285 views

select * from votetypes

oct 15 jon.doe46027
89 views

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

oct 15 PeterJames
89 views

SELECT database_id , name FROM sys.databases

oct 15 PeterJames
89 views

select * from Users where Id = 18595321

oct 15 PeterJames
89 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
13 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

217 views

Find top editors broken down by edit types

oct 15 PeterJames

30 50 100 per page

2,264,208

queries

Q&A for those involved in the field of teaching Computer Science

1.2k questions

4.7k answers

14k comments

214 tags

oct 10 most recent