Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

14 views

create table #PetOwner ( Id int identity(1,1) , Na...

jan 23
14 views

create table #PetOwner ( Id int identity(1,1) , Na...

jan 23
15 views

create table #PetOwner ( Id int identity(1,1) , Na...

jan 23
21 views

SELECT p.id , MONTH(p.CreationDate) CreationDate_ByMonth ...

jan 23 tinyint
21 views

SELECT p.id , MONTH(p.CreationDate) CreationDate_ByMonth ...

jan 23 tinyint
21 views

SELECT cnt = COUNT(p.id), avgScore = AVG(p.score) FROM po...

jan 23 tinyint
20 views

SELECT cnt = COUNT(p.id), avgScore = AVG(p.score) FROM po...

jan 23 tinyint
20 views

SELECT CNT = COUNT(P.ID), AVGSCORE = AVG(P.SCORE) FROM PO...

jan 23 tinyint
20 views

SELECT cnt = COUNT(p.id), avgScore = AVG(p.score) FROM po...

jan 23 tinyint
20 views

SELECT cnt = COUNT(p.id), avgScore = AVG(p.score) FROM po...

jan 23 tinyint
20 views

SELECT pt.name, p.id, p.score, p.tags, p.title, p.body, p...

jan 23 tinyint
20 views

SELECT cnt = COUNT(p.id), avgScore = AVG(p.score) FROM po...

jan 23 tinyint
20 views

SELECT cnt = COUNT(p.id), avgScore = AVG(p.score) FROM po...

jan 23 tinyint
14 views

DECLARE @now DATETIME = (SELECT MAX(CreationDate) FROM Po...

jan 23 peterh - PLEASE DELETE THIS ACCOUNT
14 views

/* WITH Raw AS ( SELECT Id, COALESCE(ParentId, Id) AS QId...

jan 23 peterh - PLEASE DELETE THIS ACCOUNT
14 views

SELECT COUNT(*) FROM Posts WHERE Body LIKE '% i %';

jan 23 peterh - PLEASE DELETE THIS ACCOUNT
14 views

SELECT COUNT(*) FROM Posts;

jan 23 peterh - PLEASE DELETE THIS ACCOUNT
24 views

Gold tab badges of the given user

jan 23 Martin20528
24 views

Gold tab badges of the given user

jan 23 Martin20528
11 views

select sub.c,sum(sub.c) from( SELECT COUNT(AnswerCount) a...

jan 23
11 views

SELECT COUNT(AnswerCount) as c FROM Posts GROUP BY Answer...

jan 23
11 views

select PostTypeId, count (*) from Posts where AnswerCount...

jan 23
11 views

select PostTypeId, count (*) from Posts where AnswerCount...

jan 23
11 views

select Users.DisplayName, COUNT(Badges.NAME) from Users, ...

jan 23
11 views

SELECT COUNT(AnswerCount) as c FROM Posts GROUP BY Answer...

jan 23
27 views

WITH post_CTE AS (SELECT p.id FROM posts p JOIN posttypes...

jan 23 tinyint
11 views

SELECT Text FROM PostHistory WHERE PostId = 37958 AND Pos...

jan 23 Glorfindel
11 views

SELECT Text FROM PostHistory WHERE PostId = 37958 AND Pos...

jan 23 Glorfindel
11 views

SELECT Text FROM PostHistory WHERE PostId = 37958

jan 23 Glorfindel
27 views

WITH tags_CTE AS (SELECT pMonth = MONTH(p.creationdate), ...

jan 23 tinyint
11 views

SELECT * FROM PostHistory WHERE PostId = 37958

jan 23 Glorfindel
24 views

Close reasons by frequency

jan 23 Glorfindel
24 views

Close reasons by frequency

jan 23 Glorfindel

30 50 100 per page

1,656,125

queries

Q&A for users and developers of hardware and software for Raspberry Pi

32k questions

43k answers

133k comments

577 tags

jan 17 most recent