Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

5 views

select avg(len(Body)) from Posts;

dec 3
6 views

SELECT Language, COUNT(DISTINCT p.Id) AS NonDuplicateQues...

dec 3 jon.doe46458
6 views

select top 3 len(Body) from Posts order by len(Body) desc;

dec 3
43 views

select top 50 ph1.Text, ph2.Text from PostHistory ph1 inn...

dec 3 Shinichi
6 views

select p.id, p.body, p.title from posts p where p.posttyp...

dec 3
43 views

select top 50 * from PostHistory ph1 inner join PostHisto...

dec 3 Shinichi
29 views

SELECT TOP 1 p.id -- Explicitly qualify the 'id' column t...

dec 3 jon.doe46454
39 views

SELECT tagname1, (dup * 1.0)/total, dup, total from ( SEL...

dec 3 jon.doe46463
80 views

SELECT COUNT(*) FROM Posts WHERE Tags = '<unity>'

dec 3 jon.doe46456
80 views

SELECT COUNT(*) FROM Posts WHERE Tags = 'unity'

dec 3 jon.doe46456
4 views

select count(*) from Posts p JOIN PostTags pt on (p.Id=pt...

dec 3
80 views

SELECT COUNT(*) FROM Posts WHERE Tags = '<unity>'

dec 3 jon.doe46456
4 views

select top 3 * from Posts p JOIN PostTags pt on (p.Id=pt....

dec 3
80 views

SELECT COUNT(*) FROM Posts WHERE Tags = '<unity>'

dec 3 jon.doe46456
39 views

SELECT tagname1, (dup * 1.0)/total, dup, total from ( SEL...

dec 3 jon.doe46463
80 views

SELECT COUNT(*) FROM Posts WHERE Tags = '<c++>'

dec 3 jon.doe46456
4 views

select top 3 * from Posts p JOIN PostTags pt on (p.Id=pt....

dec 3
5 views

select top 3 * from Posts p JOIN PostTags pt on (p.Id=pt....

dec 3
80 views

SELECT COUNT(*) FROM Posts WHERE CreationDate > '2023-09-...

dec 3 jon.doe46456
80 views

SELECT COUNT(*) FROM Posts WHERE CreationDate < '2023-09-...

dec 3 jon.doe46456
43 views

select top 50 * from PostHistory where PostHistoryTypeId ...

dec 3 Shinichi
43 views

select top 50 * from PostHistory where PostHistoryTypeId ...

dec 3 Shinichi
3 views

select TagName from Tags

dec 3
4 views

SELECT TOP 1 Tags from Posts where CreationDate >= 2024-1...

dec 3
80 views

SELECT COUNT(*) FROM Posts WHERE CreationDate < '2023-09-...

dec 3 jon.doe46456
4 views

select top 3 * from Posts;

dec 3
80 views

SELECT COUNT(*) FROM Posts WHERE CreationDate > '2023-09-...

dec 3 jon.doe46456
80 views

SELECT COUNT(*) FROM Posts WHERE CreationDate > '2023-09-...

dec 3 jon.doe46456
9 views

SELECT TOP 1 p.Id AS QuestionId, p.Title, p.Body, p.Score...

dec 3 jon.doe46458
5 views

select top 1 t.Id,count(*) from Posts p JOIN PostTags pt ...

dec 3
39 views

SELECT tagname1, dup/total, dup, total from ( SELECT Tags...

dec 3 jon.doe46463
3 views

select TagId from PostTags

dec 3
52 views

SELECT Tagname, YEAR(CreationDate) as CreationYear, COU...

dec 3 jon.doe46464
80 views

SELECT COUNT(*) FROM Posts WHERE CreationDate <'2023-09-15'

dec 3 jon.doe46456
80 views

SELECT COUNT(*) FROM Posts WHERE CreationDate > '2023-09-...

dec 3 jon.doe46456
3 views

SELECT TOP 1 Tags from Posts where ClosedDate >= 2024-12-...

dec 3
80 views

SELECT COUNT(*) FROM Posts WHERE CreationDate = '2023-09-...

dec 3 jon.doe46456
80 views

SELECT COUNT(*) FROM Posts WHERE CreationDate = '2018-07-...

dec 3 jon.doe46456
9 views

SELECT TOP 1 p.Id AS QuestionId, p.Title, p.Body, p.Score...

dec 3 jon.doe46458
3 views

select top 1 t.Id,count(*) from Posts p JOIN PostTags pt ...

dec 3
3 views

select top 1 Title from Posts where len(Title)<20

dec 3
74 views

SELECT Q.Id, Q.Body, A.Id, A.Body, Q.CreationDate FROM ( ...

dec 3 Brandon.Wong
3 views

select top 1 Title from Posts where len(Title)<20

dec 3
3 views

SELECT TOP 1 Tags from Posts where CreationDate >= 2024-1...

dec 3
52 views

SELECT Tagname, YEAR(CreationDate) as CreationYear, COU...

dec 3 jon.doe46464
39 views

SELECT tagname1, dup/total dup, total from ( SELECT Tags....

dec 3 jon.doe46463
80 views

SELECT COUNT(*) FROM Posts WHERE CreationDate = 2024-12-03

dec 3 jon.doe46456
9 views

SELECT TOP 1 p.Id AS QuestionId, p.Title, p.Body, p.Score...

dec 3 jon.doe46458
39 views

SELECT tagname1, dup, total from ( SELECT Tags.TagName as...

dec 3 jon.doe46463
80 views

SELECT COUNT(*) FROM Posts WHERE CreationDate = 2023-09-16

dec 3 jon.doe46456

30 50 100 per page

2,276,933

queries

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

479 questions

1k answers

2.5k comments

95 tags

nov 26 most recent