Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

114 views

SELECT TOP 10 p.Id, p.Title, p.CreationDate, p.OwnerUserI...

dec 3 MieskeB
9 views

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

dec 3
114 views

SELECT TOP 10 p.Id, p.Title, p.CreationDate, p.OwnerUserI...

dec 3 MieskeB
9 views

select top 3 * from Posts;

dec 3
114 views

SELECT TOP 10 p.Id, p.Title, p.CreationDate, p.OwnerUserI...

dec 3 MieskeB
114 views

SELECT TOP 10 p.Id, p.Title, p.OwnerUserId FROM Posts p W...

dec 3 MieskeB
33 views

SELECT TOP 10 p.id -- Explicitly qualify the 'id' column ...

dec 3 jon.doe46454
114 views

SELECT TOP 10 p.Id, p.Title, p.DeletionDate FROM Posts p ...

dec 3 MieskeB
114 views

SELECT TOP 10 p.Title, p.DeletionDate FROM Posts p WHERE ...

dec 3 MieskeB
9 views

select top 1 Tags from Posts

dec 3
33 views

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

dec 3 jon.doe46454
8 views

SELECT TOP 1 t.TagName, COUNT(*) AS TagCount FROM Posts p...

dec 3
5 views

select DATEPART(month, CreationDate), count(*) from Posts...

dec 3
5 views

select DATEPART(month, CreationDate), count(*) from Posts...

dec 3
5 views

SELECT TOP 1 t.TagName, COUNT(*) AS TagCount FROM Posts p...

dec 3
5 views

Select top 1 Tags from Posts

dec 3
20 views

SELECT Tags FROM Posts Where Tags LIKE '%bass%' And Tags ...

dec 3 jon.doe46462
6 views

select DATEPART(day, CreationDate), count(*) from Posts g...

dec 3
33 views

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

dec 3 jon.doe46454
5 views

select top 3 DATEPART(day, CreationDate) from Posts;

dec 3
33 views

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

dec 3 jon.doe46454
5 views

select top 3 DATEPART(week, CreationDate) from Posts;

dec 3
4 views

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

dec 3
78 views

SELECT Q.Id, Q.Body, A.Id, A.Body, Q.CreationDate, CASE W...

dec 3 Brandon.Wong
4 views

SELECT COUNT(DISTINCT p.Id) AS post_count FROM Posts p JO...

dec 3
7 views

select top 3 * from Posts;

dec 3
7 views

select avg(len(Body)) from Posts;

dec 3
8 views

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

dec 3 jon.doe46458
8 views

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

dec 3
49 views

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

dec 3 Shinichi
8 views

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

dec 3
49 views

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

dec 3 Shinichi
33 views

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

dec 3 jon.doe46454
42 views

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

dec 3 jon.doe46463
98 views

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

dec 3 jon.doe46456
98 views

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

dec 3 jon.doe46456
6 views

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

dec 3
98 views

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

dec 3 jon.doe46456
6 views

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

dec 3
98 views

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

dec 3 jon.doe46456
42 views

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

dec 3 jon.doe46463
98 views

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

dec 3 jon.doe46456
5 views

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

dec 3
6 views

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

dec 3
98 views

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

dec 3 jon.doe46456
98 views

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

dec 3 jon.doe46456
49 views

select top 50 * from PostHistory where PostHistoryTypeId ...

dec 3 Shinichi
49 views

select top 50 * from PostHistory where PostHistoryTypeId ...

dec 3 Shinichi
3 views

select TagName from Tags

dec 3
5 views

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

dec 3

30 50 100 per page