Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

1 view

SELECT TOP 10 * FROM posts;

dec 4
1 view

SELECT * FROM posts;

dec 4
14 views

select u.Reputation, u.DisplayName, u.WebsiteUrl, u.Locat...

dec 4
14 views

select u.Reputation, u.DisplayName, u.WebsiteUrl, u.Locat...

dec 4
16 views

select u.AboutMe from users u where AboutMe like '%php%';

dec 4
15 views

select u.AboutMe from users u

dec 4
17 views

SELECT DISTINCT Users.DisplayName, Users.Location, Users....

dec 4
20 views

select * from Tags where TagName like '%symfony%';

dec 4
18 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
20 views

select * from Tags where TagName like '%php%';

dec 4
20 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
20 views

select * from Tags

dec 4
10 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
20 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
18 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
17 views

select distinct Users.DisplayName, Users.Location, Use...

dec 4
19 views

select * from users u where location like '%Minsk%';

dec 4
10 views

select * from users u

dec 4
19 views

select * from users u

dec 4
20 views

select * from users u

dec 4
20 views

select * from users u

dec 4
20 views

select * from users u

dec 4
15 views

select * from users u

dec 4
16 views

select * from users u

dec 4
14 views

select * from users u

dec 4
14 views

select * from users u

dec 4
135 views

WITH TopTags AS ( SELECT tagid FROM posttags GROUP BY tagid

dec 4 Janis123
28 views

select count(1) from ( select pt1.postid from posttags pt...

dec 4 Janis123
28 views

select top(5) tag_combo, count(1) from (select pttg.PostI...

dec 4 Janis123
135 views

WITH TopTags AS ( SELECT top 100 tagid FROM posttags GROU...

dec 4 Janis123
135 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
13 views

select table_name as [Table(Links to Sample Data)], --sam...

dec 4
135 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
135 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
135 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
135 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
28 views

with calendar as ( select TOP(DATEDIFF(day, '2023-12-31',...

dec 4 Janis123
135 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
135 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
135 views

WITH TopTags AS ( SELECT top 5 pt.tagId, t.tagname, COUNT...

dec 4 Janis123
63 views

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

dec 4 Bowen.Zhou
63 views

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

dec 4 Bowen.Zhou
135 views

select postid, count(1) from comments c where c.creationd...

dec 4 Janis123
63 views

select * from comments

dec 4 Bowen.Zhou
63 views

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

dec 4 Bowen.Zhou
63 views

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

dec 4 Bowen.Zhou
63 views

select * from comments

dec 4 Bowen.Zhou
135 views

WITH aggregated_votes AS ( SELECT PostId, COUNT(CASE WHEN...

dec 4 Janis123
63 views

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

dec 4 Bowen.Zhou
19 views

select id,name from closereasontypes

dec 4
135 views

WITH aggregated_votes AS ( SELECT PostId, COUNT(CASE WHEN...

dec 4 Janis123
135 views

WITH aggregated_votes AS ( SELECT PostId, COUNT(CASE WHEN...

dec 4 Janis123
135 views

select top 5 p.Id, p.tags from posts p inner join ( selec...

dec 4 Janis123
135 views

select p.Id, count(1) from posts p inner join ( select Po...

dec 4 Janis123
135 views

select p.Id, p.tags from posts p inner join ( select PostId

dec 4 Janis123
20 views

select id,name from votetypes

dec 4
20 views

select id,name from posttypes

dec 4
10 views

select id,name from posthistorytypes

dec 4
20 views

select id,name from posthistorytypes

dec 4
20 views

select id,name from posthistorytypes

dec 4
19 views

select id,name from posthistorytypes

dec 4
11 views

SELECT YEAR(CreationDate) AS year, t.TagName AS tag, COUN...

dec 4 jon.doe46483
11 views

SELECT u.Id AS [User Link], CONCAT('https://unix.stackexc...

dec 4
11 views

SELECT YEAR(CreationDate) AS Year, TagName, COUNT(*) AS Q...

dec 4

30 50 100 per page

2,277,109

queries

Q&A about the site for people interested in the history and origins of science and mathematics

156 questions

224 answers

531 comments

73 tags

nov 20 most recent