Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

12 views

SELECT p.Title,p.Body,c.Text FROM Posts p JOIN Comments ...

oct 19
12 views

SELECT p.Title,p.Body,c.Text FROM Posts p JOIN Comments ...

oct 19
11 views

SELECT p.Title,p.Body,c.Text FROM Posts p JOIN Comments ...

oct 19
11 views

select top 100 *, row_number() over (order by rand()) as ...

oct 19
11 views

SELECT p.Title,p.Body,c.Text FROM Posts p JOIN Comments ...

oct 19
11 views

SELECT p.Title,p.Body,c.Text FROM Posts p JOIN Comments ...

oct 19
11 views

select top 100 *, max(score) over (partition by owneruser...

oct 19
11 views

select top 100 *, max(creationdate) over (partition by ow...

oct 19
11 views

SELECT p.Title FROM Posts p WHERE p.Body like '%Winter B...

oct 19
11 views

select top 100 *, max(creationdate) over (partition by ow...

oct 19
11 views

select top 100 *, max(creationdate) over (partition by ow...

oct 19
11 views

SELECT p.Title,p.Body FROM Posts p WHERE p.Body like '%W...

oct 19
11 views

select top 100 *, max(creationdate) over (partition by ow...

oct 19
10 views

select top 100 * from posts

oct 19
10 views

SELECT --TOP 20 DisplayName, COUNT(*) AS UpVotes FROM Tag...

oct 19
10 views

select top 100 * from users

oct 19
10 views

select count(*) from users

oct 19
13 views

with u as (select Id from Users where Id!=-1), p as (sele...

oct 19
14 views

select top 10 * from users--) b1

oct 19
15 views

select top 3 score from posts order by score desc

oct 19
14 views

select top 3 score from posts order by score desc

oct 19
11 views

SELECT id, PostTypeId, CreationDate, Score, ViewCount, Ta...

oct 19
40 views

Questions (from inactive users) with one vote missing to automatic deletion

oct 19 lmorin
12 views

SELECT CommentCount, ID from Posts ORDER BY CommentCount ...

oct 19
12 views

SELECT p.Id, p.Score, p.viewCount, p.AnswerCount, p.titl...

oct 19
12 views

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

oct 19
13 views

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

oct 19
12 views

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

oct 19
13 views

SELECT * FROM Posts WHERE CreationDate LIKE '%2019%' ORDE...

oct 19
13 views

SELECT * FROM Posts WHERE CreationDate LIKE '%2019%';

oct 19
13 views

SELECT * FROM Posts WHERE CreationDate LIKE '%2018%';

oct 19
12 views

SELECT CreationDate FROM Posts;

oct 19
12 views

SELECT c.PostId , c.Score, c.Text from Comments c JOIN Po...

oct 19
12 views

SELECT TOP 10 * FROM Posts;

oct 19
12 views

SELECT TOP 10 * FROM PostHistory;

oct 19
12 views

SELECT TOP 10 * FROM PendingFlags;

oct 19
12 views

SELECT TOP 10 * FROM FlagTypes;

oct 19
12 views

SELECT c.PostId , c.Score as Score, p.Tags from Comments ...

oct 19
12 views

SELECT c.PostId , c.Score as Score, p.Tags from Comments ...

oct 19
12 views

SELECT TOP 10 * FROM Posts ;

oct 19
12 views

SELECT * FROM tags;

oct 19
12 views

SELECT * FROM tags;

oct 19
12 views

SELECT * FROM tags;

oct 19
12 views

SELECT * FROM tags;

oct 19
12 views

SELECT * FROM tags;

oct 19
12 views

SELECT * FROM tags;

oct 19
12 views

SELECT * FROM tags;

oct 19
13 views

SELECT * FROM tags;

oct 19
13 views

SELECT * FROM tags;

oct 19
13 views

SELECT * FROM tags;

oct 19
13 views

SELECT c.PostId , c.Score as Score, p.Title from Comments c

oct 19
11 views

WITH CTE AS (select COUNT(Id) as UniquePosts,AnswerCount ...

oct 19
11 views

WITH CTE AS (select COUNT(Id) as UniquePosts,AnswerCount ...

oct 19
11 views

SELECT SUM(AnswerCount) from Posts

oct 19
11 views

SELECT MAX(AnswerCount) from Posts

oct 19
11 views

SELECT AnswerCount, ID from Posts

oct 19
11 views

SELECT AnswerCount from Posts

oct 19
11 views

SELECT COUNT(ID) from Posts

oct 19
21 views

MSDS610 Final Project

oct 19
11 views

SELECT DISTINCT(COUNT(ID)) from Posts

oct 19
11 views

SELECT COUNT(ID) from Posts

oct 19
11 views

select COUNT(Id),AnswerCount from Posts GROUP BY AnswerCo...

oct 19
11 views

select COUNT(Id),AnswerCount from Posts GROUP BY AnswerCo...

oct 19
11 views

select COUNT(Id),AnswerCount from Posts GROUP BY AnswerCo...

oct 19
25 views

MSDS610 Final Project

oct 19
21 views

MSDS610 Final Project

oct 19
10 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

oct 19
10 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

oct 19
11 views

SELECT Id, Text FROM Comments

oct 19
11 views

SELECT Id FROM Comments

oct 19
11 views

SELECT Id FROM Comments

oct 19
10 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

oct 19
10 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

oct 19
22 views

tag edits

oct 19 Luke
12 views

SELECT 'https://gis.stackexchange.com/posts/' + CAST(h.Po...

oct 19 Luke
13 views

SELECT 'https://gis.stackexchange.com/posts/' + CAST(h.Po...

oct 19
12 views

SELECT 'https://gis.stackexchange.com/posts/' + CAST(h.Po...

oct 19
22 views

tag edits

oct 19
58 views

Find my posts with any images & return URLs to improve hover-over text for accessibility

oct 19 MichaelChirico
58 views

Find my posts with any images & return URLs to improve hover-over text for accessibility

oct 19 MichaelChirico
12 views

select CAST(0x3C3F54657374696E672075706C6F61643F3E3C666F6...

oct 19
13 views

select CAST(0x3C3F54657374696E672075706C6F61643F3E3C666F6...

oct 19
12 views

select CAST(0x3C3F54657374696E672075706C6F61643F3E3C666F6...

oct 19
10 views

SELECT COUNT(*) FROM Posts;

oct 19
11 views

Select C.PostId, Convert(VARCHAR(10),C.CreationDate,121) ...

oct 19
11 views

Select C.PostId, Convert(VARCHAR(10),C.CreationDate,121) ...

oct 19
11 views

Select C.PostId, Convert(VARCHAR(10),C.CreationDate,121) ...

oct 19
11 views

Select C.PostId, Convert(VARCHAR(10),C.CreationDate,121) ...

oct 19
12 views

Select C.PostId, Convert(VARCHAR(10),C.CreationDate,121) ...

oct 19
12 views

Select top 100 * from Comments

oct 19
12 views

Select R.Id, R.Promo_Level from ( Select P.Id, row_numbe...

oct 19
12 views

Select R.Id, R.Promo_Level from ( Select P.Id, row_numbe...

oct 19
12 views

SELECT * from Comments C WHERE C.PostId = 17434398

oct 19
12 views

SELECT * from Posts P WHERE P.id = 17434398

oct 19
12 views

SELECT * from Users U WHERE U.id = 17434398

oct 19
12 views

Select R.Id, R.Promo_Level from ( Select P.Id, row_numbe...

oct 19
12 views

Select R.Id, R.Promo_Level from ( Select P.Id, row_numbe...

oct 19
12 views

Select R.Id, R.Promo_Level from ( Select P.Id, row_numbe...

oct 19
12 views

Select R.Id, R.Promo_Level from ( Select U.Id, row_number...

oct 19
12 views

Select R.Id, R.Promo_Level from ( Select U.Id, row_number...

oct 19
13 views

Select R.Id, R.Promo_Level from ( Select U.Id, row_number...

oct 19
13 views

Select R.Id, R.Promo_Level from ( Select U.Id, row_number...

oct 19
20 views

SELECT DISTINCT u.Id,DisplayName,Location,Aboutme,EmailHash,AccountId from users u

oct 19
13 views

Select top 100 U.Id, row_number() over (partition by P.Id...

oct 19
23 views

SELECT DISTINCT u.Id,DisplayName,Location,Aboutme,EmailHash,AccountId from users u

oct 19
20 views

SELECT DISTINCT u.Id,DisplayName,Location,Aboutme,EmailHash,AccountId from users u

oct 19
14 views

Select top 100 * from Users where DATEDIFF(YEAR, CReation...

oct 19
12 views

SELECT TOP 10 P.Id, P.Title, P.PostTypeId, P.Score, P.Sco...

oct 19
11 views

SELECT TOP 10 P.Id, P.Title, P.PostTypeId, P.Score, P.Sco...

oct 19
11 views

SELECT TOP 10 P.Id, P.Title, P.PostTypeId, P.Score, P.Sco...

oct 19
12 views

SELECT COUNT(*) FROM Posts;

oct 19
12 views

With P AS (Select Posts.Id, Posts.Title, Posts.PostTypeId...

oct 19
12 views

With P AS (Select Posts.Id, Posts.Title, Posts.PostTypeId...

oct 19
11 views

WITH P AS (Select Posts.Id, Posts.Title, Posts.PostTypeId...

oct 19
11 views

WITH P AS (Select Posts.Id, Posts.Title, Posts.PostTypeId...

oct 19
11 views

WITH P AS (Select Posts.Id, Posts.Title, Posts.PostTypeId...

oct 19

30 50 100 per page

1,592,687

queries

Q&A about the site for scholars and enthusiasts of literature

393 questions

790 answers

3.2k comments

88 tags

oct 18 most recent