Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

351 views

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

dec 4 jon.doe45585
351 views

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

dec 4 jon.doe45585
351 views

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

dec 4 jon.doe45585
89 views

select * from sys.partitions;

dec 4 jon.doe46475
89 views

SELECT t.NAME AS TableName, p.rows AS RowCounts, SUM(a.to...

dec 4 jon.doe46475
89 views

SELECT t.NAME AS TableName, p.rows AS RowCounts, SUM(a.to...

dec 4 jon.doe46475
89 views

SELECT t.NAME AS TableName, p.rows AS RowCounts, SUM(a.to...

dec 4 jon.doe46475
89 views

SELECT t.NAME AS TableName, p.rows AS RowCounts, SUM(a.to...

dec 4 jon.doe46475
89 views

select * from sys.schemas;

dec 4 jon.doe46475
31 views

wifi

dec 4
32 views

wifi

dec 4
30 views

wifi

dec 4
31 views

wifi

dec 4
31 views

wifi

dec 4
30 views

wifi

dec 4
34 views

WITH DistinctTags AS ( SELECT Posts.Id AS [Post ID], Tags...

dec 4
17 views

SELECT Posts.Id as [Post ID], ...

dec 4
34 views

SELECT Posts.Id as [Post ID], ...

dec 4
34 views

SELECT * FROM Users WHERE Reputation > 100 AND CreationDa...

dec 4
32 views

SELECT * FROM Users WHERE Reputation > 100 AND CreationDa...

dec 4
32 views

SELECT * FROM Users WHERE Reputation > 0 AND CreationDate...

dec 4
33 views

SELECT * FROM Users WHERE Reputation > 0 AND CreationDate...

dec 4
33 views

SELECT * FROM Users WHERE Reputation > 0 AND CreationDate...

dec 4
33 views

SELECT * FROM Users WHERE Reputation > 0 AND CreationDate...

dec 4
33 views

SELECT * FROM Users WHERE Reputation > 0 AND CreationDate...

dec 4
17 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
33 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
33 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
33 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
33 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
32 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
32 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
34 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
16 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
16 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
16 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
17 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
16 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
17 views

SELECT TOP 500 * FROM Users WHERE Reputation > 0 AND Crea...

dec 4
18 views

Select * from Postlinks

dec 4
38 views

SELECT Users.DisplayName, Users.Id, COUNT(Posts.Id) AS To...

dec 4
19 views

SELECT OwnerUserId, COUNT(*) AS NumPosts, SUM(UpVotes) AS...

dec 4
20 views

SELECT Users.DisplayName, Users.Id, COUNT(Posts.Id) AS To...

dec 4
38 views

SELECT Users.DisplayName, Users.Id, COUNT(Posts.Id) AS To...

dec 4
45 views

select top 100 * from users where year(creationDate) = 2023

dec 3
44 views

select top 100 * from users where year(creationDate) = 2022

dec 3
44 views

select top 100 * from users where year(creationDate) = 2021

dec 3
44 views

select top 100 * from users where year(creationDate) = 2021

dec 3
44 views

select top 100 * from users where year(creationDate) = 2020

dec 3
44 views

select top 100 * from users where year(creationDate) = 2021

dec 3
25 views

WITH t1 AS (SELECT * FROM Posts WHERE Tags...

dec 3
26 views

SELECT * FROM Posts WHERE Tags LIKE '%cel...

dec 3
24 views

SELECT Id FROM Posts WHERE Tags LIKE '%ce...

dec 3
44 views

select top 100 * from users where year(creationDate) = 2023

dec 3
44 views

select top 100 * from users where year(creationDate) = 2022

dec 3
25 views

select top 100 * from users where year(creationDate) = 2021

dec 3
44 views

select top 100 * from users where year(creationDate) = 2021

dec 3
44 views

select top 100 * from users where year(creationDate) = 2021

dec 3
44 views

select top 100 * from users where year(creationDate) = 2021

dec 3
44 views

select top 100 * from users where year(creationDate) = 2021

dec 3
44 views

select top 100 * from users where year(creationDate) = 2021

dec 3
44 views

select top 100 * from users where year(creationDate) = 2021

dec 3
44 views

select top 100 * from users where year(creationDate) = 2021

dec 3
45 views

select top 100 * from users where year(creationDate) = 2021

dec 3
25 views

WITH tag_rows AS (SELECT PostTags.*, T...

dec 3
24 views

Select TOP 100 * from users where Year(creationDate) = 2020

dec 3
1

7.7k views

Count of answers by user over time

dec 3 Frank van Puffelen
168 views

SELECT TOP 500 P.OwnerUserId AS UserId, COUNT(P.Id) AS To...

dec 3 jon.doe45853
1k views

Number of questions in Stack Overflow

dec 3 Frank van Puffelen
1k views

Number of questions in Stack Overflow

dec 3 Frank van Puffelen
1k views

Number of questions in Stack Overflow

dec 3 Frank van Puffelen
24 views

SELECT p.Id AS [ParentPostID], p.Id AS [PostID], CONCAT('...

dec 3
27 views

WITH tag_rows AS (SELECT PostTags.*, TagName

dec 3

30 50 100 per page