Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

5 views

with GetDates As ( select cast('2023-03-01' as date) as ...

mar 20
5 views

with GetDates As ( select cast('2023-03-01' as date) as ...

mar 20
5 views

with GetDates As ( select cast('2023-01-03' as date) as ...

mar 20
5 views

select top 5 ROW_NUMBER() OVER (ORDER BY u.reputation des...

mar 20
6 views

SELECT ps.title, t.TagName FROM PostTags pt JOIN Tags t O...

mar 20
6 views

select top 5 ROW_NUMBER() OVER (partition by u.reputation...

mar 20
6 views

SELECT ps.title, t.TagName FROM PostTags pt JOIN Tags t O...

mar 20
6 views

select top 5 ROW_NUMBER() OVER (partition by u.id ORDER B...

mar 20
6 views

SELECT ps.title, t.TagName FROM PostTags pt JOIN Tags t O...

mar 20
6 views

select top 5 ROW_NUMBER() OVER (ORDER BY u.reputation des...

mar 20
6 views

SELECT ps.title, t.TagName FROM PostTags pt JOIN Tags t O...

mar 20
6 views

select top 5 ROW_NUMBER() OVER (ORDER BY u.reputation) rn...

mar 20
6 views

SELECT ps.title, t.TagName FROM PostTags pt JOIN Tags t O...

mar 20
6 views

SELECT ps.title, t.TagName FROM PostTags pt JOIN Tags t O...

mar 20
6 views

SELECT ps.title, t.TagName FROM PostTags pt JOIN Tags t O...

mar 20
6 views

SELECT top 20 ps.title, t.TagName FROM PostTags pt JOIN T...

mar 20
7 views

SELECT top 20 ps.title, t.TagName FROM PostTags pt JOIN T...

mar 20
7 views

select u.id ,u.reputation ,ROW_NUMBER() OVER (ORDER BY u....

mar 20
7 views

select u.id ,u.reputation ,ROW_NUMBER() OVER (ORDER BY u....

mar 20
7 views

select u.id ,u.reputation ,ROW_NUMBER() OVER (ORDER BY u....

mar 20
7 views

select u.id ,u.reputation ,ROW_NUMBER() OVER (ORDER BY u....

mar 20
8 views

select u.id ,u.reputation ,ROW_NUMBER() OVER (ORDER BY u....

mar 20
8 views

select u.id ,u.reputation ,ROW_NUMBER() OVER (ORDER BY u....

mar 20
8 views

select top 10 u.id ,u.reputation ,ROW_NUMBER() OVER (ORDE...

mar 20
9 views

select top 10 ROW_NUMBER() OVER (ORDER BY u.reputation DE...

mar 20
9 views

select top 10 u.id ,u.reputation ,ROW_NUMBER() OVER (ORDE...

mar 20
9 views

select u.id ,u.reputation ,ROW_NUMBER() OVER (ORDER BY u....

mar 20
10 views

select u.id ,u.reputation FROM users u GROUP BY u.id, u.r...

mar 20
10 views

select ROW_NUMBER() OVER (ORDER BY u.reputation DESC) rn ...

mar 20
10 views

select ROW_NUMBER() OVER (ORDER BY u.reputation DESC) rn ...

mar 20
10 views

select top 5 * from users u order by u.reputation desc

mar 20
10 views

select top 50 * from users u order by u.reputation

mar 20
9 views

SELECT top 20 ps.title, ps.tags FROM PostTags pt JOIN Tag...

mar 20
9 views

select ROW_NUMBER() OVER (ORDER BY AVG(u.reputation) DESC...

mar 20
9 views

select top 50 * from users p

mar 20
13 views

SELECT * FROM PostNotices

mar 20 Yuanhong
13 views

SELECT * FROM PostNoticeTypes

mar 20 Yuanhong
9 views

select top 50 * from posts

mar 20
9 views

select * from posts

mar 20
13 views

SELECT * FROM Votes

mar 20 Yuanhong
9 views

SELECT top 20 ps.title, ct.name FROM PendingFlags pf JOIN...

mar 20
13 views

SELECT * FROM PostFeedback

mar 20 Yuanhong
9 views

SELECT Id [User Link], Reputation, DisplayName, Location,...

mar 20
13 views

SELECT * FROM PostHistory

mar 20 Yuanhong
9 views

SELECT top 20 ft.Name, ft.description, pf.PostId, pf.Dupl...

mar 20
9 views

SELECT top 20 ft.Name, ft.description, pf.PostId, pf.Dupl...

mar 20
9 views

SELECT top 20 ft.name, ft.description, pf.PostId, pf.Dupl...

mar 20
9 views

SELECT Id [User Link], Reputation, DisplayName, Location,...

mar 20
9 views

SELECT Id [User Link], Reputation, DisplayName, Location,...

mar 20
13 views

SELECT * FROM FlagTypes

mar 20 Yuanhong
13 views

SELECT * FROM ReviewRejectionReasons

mar 20 Yuanhong
13 views

SELECT * FROM VoteTypes

mar 20 Yuanhong
13 views

SELECT * FROM PostFeedback

mar 20 Yuanhong
9 views

SELECT top 20 ps.id, ps.CreationDate, ps.Score, cm.text, ...

mar 20
9 views

SELECT ps.id, ps.CreationDate, ps.Score, cm.text, bd.nam...

mar 20
8 views

SELECT ps.id, ps.CreationDate, ps.Score, cm.text, bd.nam...

mar 20
13 views

SELECT * FROM PostNoticeTypes

mar 20 Yuanhong
8 views

SELECT top 20 ps.id, ps.CreationDate, ps.Score, cm.text, ...

mar 20
13 views

SELECT * FROM PendingFlags

mar 20 Yuanhong
8 views

SELECT top 20 ps.id, ps.CreationDate, ps.Score, cm.text, ...

mar 20
9 views

SELECT * FROM PendingFlags

mar 20 Yuanhong
8 views

SELECT ps.id, ps.CreationDate, ps.Score, cm.text, bd.name...

mar 20
9 views

SELECT * FROM CloseAsOffTopicReasonTypes

mar 20 Yuanhong
9 views

SELECT * FROM CloseReasonTypes

mar 20 Yuanhong
8 views

SELECT * FROM CloseReasonTypes

mar 20 Yuanhong
8 views

SELECT TOP 10 Body FROM Posts;

mar 20
9 views

SELECT TOP 10 PostTypeId FROM Posts;

mar 20
8 views

SELECT TOP 10 PostTypeId FROM Posts;

mar 20
8 views

SELECT TOP 20 ps.id, ps.CreationDate, ps.Score, cm.text, ...

mar 20
8 views

SELECT TOP 20 ps.id, ps.CreationDate, ps.Score, cm.text F...

mar 20
9 views

select SUM(CASE WHEN d1.Posts_cnt > 10 THEN 1 ELSE 0 END)...

mar 20
10 views

SELECT TOP 20 v.PostId , v.VoteTypeId, v.CreationDate, vt...

mar 20
10 views

SELECT TOP 20 v.PostId , v.VoteTypeId, v.CreationDate, vt...

mar 20
9 views

SELECT TOP 20 v.PostId , v.VoteTypeId, v.CreationDate, vt...

mar 20
9 views

SELECT TOP 20 v.PostId , v.VoteTypeId, v.CreationDate, vt...

mar 20
9 views

SELECT TOP 20 comments.id, users.Reputation,comments.Cont...

mar 20
9 views

SELECT TOP 20 comments.id FROM Comments join Users on Co...

mar 20
9 views

with liela_tabula as ( select 'test test3 test2 test1' ve...

mar 20
9 views

with liela_tabula as ( select 'test test3 test1' vertibu_...

mar 20
8 views

select 'test test3 test1' vertibu_list

mar 20
8 views

SELECT TOP 20 replace(title, 'null', 'n/a') Title, Body, ...

mar 20
10 views

Select u.Reputation from posts p join Users u on (p.owner...

mar 20
10 views

select SUM(CASE WHEN d1.Posts_cnt > 10 THEN 1 ELSE 0 END)...

mar 20
10 views

select SUM(CASE WHEN d1.Posts_cnt > 10 THEN 1 ELSE 0 END)...

mar 20
10 views

SELECT SUM(CASE WHEN cnt is null THEN 0 ELSE 1 END) as Nu...

mar 20
10 views

SELECT SUM(CASE WHEN cnt is null THEN 0 ELSE 1 END) as Nu...

mar 20
9 views

select score from posts

mar 20
10 views

select score from posts

mar 20
8 views

select score from posts

mar 20
9 views

select score from posts

mar 20
9 views

select score from posts

mar 20
9 views

select SUM(CASE WHEN d1.Posts_cnt > 10 THEN 1 ELSE 0 END)...

mar 20
10 views

select SUM(CASE WHEN d1.Posts_cnt > 10 THEN 1 ELSE 0 END)...

mar 20
10 views

SELECT SUM(CASE WHEN cnt is null THEN 0 ELSE 1 END) as Nu...

mar 20
10 views

select SUM(CASE WHEN Posts_cnt > 10 THEN 1 ELSE 0 END) as...

mar 20
10 views

WITH getdates AS ( SELECT CAST('2023-01-01' AS DATE) AS t...

mar 20
10 views

WITH getdates AS ( SELECT CAST('2023-01-01' AS DATE) AS t...

mar 20
10 views

select p.OwnerUserId, count (p.OwnerUserId) as Posts_cnt ...

mar 20
10 views

WITH getdates AS ( SELECT CAST('2023-01-01' AS DATE) AS t...

mar 20
10 views

WITH getdates AS ( SELECT CAST('2023-01-01' AS DATE) AS t...

mar 20
10 views

SELECT u.Id AS [User Link], SUM(CASE WHEN p.PostTypeId = ...

mar 20 jon.doe25286
10 views

SELECT u.Id AS [User Link], SUM(CASE WHEN p.PostTypeId = ...

mar 20 jon.doe25286
9 views

WITH getdates AS ( SELECT CAST('2023-01-01' AS DATE) AS t...

mar 20
10 views

WITH getdates AS ( SELECT CAST('2023-01-01' AS DATE) AS t...

mar 20
10 views

DECLARE @dateBegin DATETIME = '2023-02-15' DECLARE @dateE...

mar 20
10 views

DECLARE @dateBegin DATETIME = '2022-02-15' DECLARE @dateE...

mar 20

30 50 100 per page

2,074,768

queries

Q&A about the site for expert genealogists and people interested in genealogy or family history

491 questions

998 answers

3k comments

83 tags

mar 19 most recent