Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

102 views

SELECT COUNT(*) FROM Posts WHERE CreationDate > 15/09/2023

dec 3 jon.doe46456
12 views

SELECT TOP 1 id--, FROM Posts WHERE CreationDate >= '2024...

dec 3 Kostas
56 views

SELECT * FROM PostTags pt, Posts p, tags t WHERE p.Id =...

dec 3 jon.doe46464
3 views

SELECT TOP 1 id--, FROM Posts WHERE PostTypeId = 1 AND Cr...

dec 3 jon.doe46454
56 views

SELECT COUNT(*) FROM Posts WHERE Tags LIKE '%piano%' SE...

dec 3 jon.doe46464
43 views

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

dec 3 Brandon.Wong
2 views

DECLARE @UserId int = ##UserId## SELECT (CAST(Count(a.I...

dec 3 RedWind
49 views

SELECT TOP 5 Tags.TagName, COUNT(distinct PostTags.PostId...

dec 3 jon.doe46463
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT TOP(10000...

dec 3 Brandon.Wong
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT TOP(10) *...

dec 3 Brandon.Wong
49 views

SELECT TOP 5 Tags.TagName, COUNT(distinct PostTags.PostId...

dec 3 jon.doe46463
15 views

select num.TagName as Tag, row_number() over (order by r...

dec 3 Anindita.Sarkar
15 views

select num.TagName as Tag, row_number() over (order by r...

dec 3 Anindita.Sarkar
56 views

SELECT pt.TagId, COUNT(*) FROM PostTags pt, Posts p, ta...

dec 3 jon.doe46464
23 views

SELECT count(*) FROM Posts WHERE Tags LIKE '%piano%'

dec 3 jon.doe46462
3 views

SELECT * FROM TagSynonyms;

dec 3
56 views

SELECT COUNT(*) FROM Posts WHERE Tags LIKE '%piano%'

dec 3 jon.doe46464
23 views

SELECT * FROM Posts WHERE Tags LIKE '%piano%'

dec 3 jon.doe46462
3 views

SELECT * FROM Tags;

dec 3
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT TOP(10) *...

dec 3 Brandon.Wong
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT TOP(10) *...

dec 3 Brandon.Wong
49 views

SELECT TOP 5 Tags.TagName, COUNT(distinct PostTags.PostId...

dec 3 jon.doe46463
15 views

select num.TagName as Tag, row_number() over (order by r...

dec 3 Anindita.Sarkar
102 views

SELECT TOP 3 Id FROM Posts WHERE CreationDate > 02/12/2024

dec 3 jon.doe46456
30 views

SELECT TOP 100000 Posts.Id AS postId, LEN(Posts.Body) AS ...

dec 3 jon.doe46448
3 views

SELECT TOP 1 Tags from Posts;

dec 3
4 views

select top 100 * from PostHistory where PostHistoryTypeId...

dec 3
4 views

select max(Title) from Posts where len(Title)<20

dec 3
30 views

SELECT TOP 100000 Posts.Id AS postId, LEN(Posts.Body) AS ...

dec 3 jon.doe46448
7 views

SELECT COUNT(Id) FROM Posts WHERE PostTypeId=1

dec 3 jon.doe46458
15 views

select num.TagName as Tag, row_number() over (order by r...

dec 3 Anindita.Sarkar
102 views

SELECT TOP 3 Id FROM Posts

dec 3 jon.doe46456
30 views

SELECT TOP 100000 Posts.Id AS postId, LEN(Posts.Body) AS ...

dec 3 jon.doe46448
4 views

SELECT max(Count) FROM Tags;

dec 3
4 views

SELECT top 10 Id, Title, Body, Tags FROM posts WHERE Post...

dec 3
12 views

SELECT TOP 1 id--, FROM Posts WHERE PostTypeId = 1

dec 3 Kostas
4 views

SELECT TOP 3 Id FROM Posts

dec 3 jon.doe46456
4 views

select Title from Posts where len(Title)<20

dec 3
11 views

SELECT date2, count(id) as cnt FROM ( SELECT FORMAT (d.C...

dec 3 David.Xuang
15 views

select count(PostId) from Tags, PostTags, Posts where Po...

dec 3 Anindita.Sarkar
5 views

SELECT YEAR(CreationDate) AS year, COUNT(*) AS count FROM...

dec 3
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT TOP 10 * ...

dec 3 Brandon.Wong
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT TOP 10 * ...

dec 3 Brandon.Wong
56 views

SELECT pt.TagId, COUNT(*) FROM PostTags pt, Posts p, tag...

dec 3 jon.doe46464
30 views

SELECT TOP 10 Posts.Id AS postId, LEN(Posts.Body) AS post...

dec 3 jon.doe46448
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT TOP 10 * ...

dec 3 Brandon.Wong
2 views

SELECT Id from PostHistory group by Id having count (*) >...

dec 3
4 views

select top 100 * from PostHistory

dec 3
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT TOP 10 * ...

dec 3 Brandon.Wong
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT TOP 10 * ...

dec 3 Brandon.Wong
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT TOP 10 * ...

dec 3 Brandon.Wong
3 views

select top 10 * from PostHistory

dec 3
4 views

select top 10 * from PostHistory

dec 3
4 views

select top 10 * from PostHistory

dec 3
2 views

select top 10 * from PostHistory

dec 3
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT * FROM Po...

dec 3 Brandon.Wong
43 views

SELECT Q.Id, Q.Body, A.Id, A.Body FROM ( SELECT * FROM Po...

dec 3 Brandon.Wong
4 views

SELECT AVG(CAST(tmp.HasAcceptedAnswer AS FlOAT)) FROM ( S...

dec 3 jon.doe46451
38 views

Testing query

dec 3 jon.doe46453
25 views

Posts containing a very short title

dec 3 jon.doe46450
3 views

select count(*) from Posts where len(Title)<10

dec 3
56 views

SELECT pt.TagId, COUNT(*) FROM PostTags pt, Posts p, tag...

dec 3 jon.doe46464
2 views

select top 100 PostId as [Post Link], * from votes join p...

dec 3
2 views

select top 100 PostId as [Post Link], * from votes join p...

dec 3
38 views

Testing query

dec 3 jon.doe46453
56 views

SELECT pt.PostId, pt.TagId, COUNT(*) FROM PostTags pt, P...

dec 3 jon.doe46464
3 views

SELECT AVG(CAST(tmp.HasAcceptedAnswer AS FlOAT)) FROM ( S...

dec 3 jon.doe46451
23 views

SELECT * FROM TagSynonyms

dec 3 jon.doe46462
2 views

SELECT Count FROM Tags;

dec 3
56 views

SELECT pt.PostId, pt.TagId, t.TagName, COUNT(*) FROM Pos...

dec 3 jon.doe46464
38 views

Testing query

dec 3 jon.doe46453
38 views

Testing query

dec 3 jon.doe46453
38 views

Testing query

dec 3 jon.doe46453
2 views

SELECT Id from PostHistory group by Id having count (*) >...

dec 3
2 views

SELECT Id from PostHistory group by Id having count (*) >...

dec 3
51 views

select top 50 * from SuggestedEdits where ApprovalDate is...

dec 3 Shinichi
51 views

select count(*) from SuggestedEdits where ApprovalDate is...

dec 3 Shinichi
51 views

select count(*) from SuggestedEdits where ApprovalDate is...

dec 3 Shinichi
51 views

select top 50 * from SuggestedEdits where ApprovalDate is...

dec 3 Shinichi
11 views

SELECT date2, count(id) as cnt FROM ( SELECT FORMAT (d.C...

dec 3 David.Xuang
51 views

select count(*) from SuggestedEdits where ApprovalDate is...

dec 3 Shinichi
56 views

SELECT * FROM PostTags pt, Posts p WHERE p.Id = pt.PostI...

dec 3 jon.doe46464
2 views

SELECT Id FROM Posts WHERE CreationDate > 02/12/2024

dec 3 jon.doe46456
10 views

SELECT LEN(title), AnswerCount FROM Posts WHERE PostTypeI...

dec 3 jon.doe46466
9 views

SELECT LEN(title), AnswerCount FROM Posts WHERE PostTypeI...

dec 3 jon.doe46452
30 views

SELECT TOP 100000 Posts.Id AS postId, LEN(Posts.Body) AS ...

dec 3 jon.doe46448
5 views

SELECT AVG(CAST(tmp.HasAcceptedAnswer AS FlOAT)) FROM ( S...

dec 3 jon.doe46451
51 views

select count(*) from SuggestedEdits where ApprovalDate is...

dec 3 Shinichi
49 views

SELECT TOP 5 Posts.Tags, COUNT(distinct Posts.Id) FROM Po...

dec 3 jon.doe46463
2 views

select q.* from Posts q where CommunityOwnedDate is null ...

dec 3
49 views

SELECT TOP 5 Posts.Tags, COUNT(distinct Posts.Id) FROM Po...

dec 3 jon.doe46463
56 views

SELECT * FROM PostTags pt, Posts p WHERE p.Id = pt.PostI...

dec 3 jon.doe46464
5 views

SELECT AVG(CAST(tmp.HasAcceptedAnswer AS FlOAT)) FROM ( S...

dec 3 jon.doe46451
43 views

SELECT TOP 10 Q.Id, A.Body FROM Posts as Q JOIN Posts as ...

dec 3 Brandon.Wong
38 views

Testing query

dec 3 jon.doe46453
56 views

SELECT * FROM PostTags pt, Posts p WHERE p.Id = pt.PostI...

dec 3 jon.doe46464
2 views

SELECT TOP 10 p.Title, COUNT(Comments.Id) AS CommentCount...

dec 3 MieskeB
56 views

SELECT DISTINCT p.Id FROM PostTags pt, Posts p WHERE p.I...

dec 3 jon.doe46464
26 views

Testing post query

dec 3 jon.doe46451
9 views

SELECT LEN(title), AnswerCount FROM Posts WHERE PostTypeI...

dec 3 jon.doe46452
10 views

SELECT LEN(Title), AnswerCount FROM Posts WHERE PostTypeI...

dec 3 jon.doe46466
49 views

SELECT TOP 4 Posts.Tags FROM PostLinks LEFT JOIN Posts on...

dec 3 jon.doe46463
2 views

select num.TagName as Tag, row_number() over (order by r...

dec 3 Anindita.Sarkar

30 50 100 per page

2,277,180

queries

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

159 questions

300 answers

1.2k comments

72 tags

oct 15 most recent