Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

65 views

select se.OwnerUserId, u.Reputation, u.UpVotes, u.DownVot...

oct 8 PeterJames
65 views

select se.OwnerUserId, u.Reputation, u.UpVotes, u.DownVot...

oct 8 PeterJames
65 views

select se.OwnerUserId, u.Reputation, u.UpVotes, u.DownVot...

oct 8 PeterJames
65 views

select se.OwnerUserId, u.Reputation, u.UpVotes, u.DownVot...

oct 8 PeterJames
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
65 views

select se.OwnerUserId, u.Reputation, count(*) as Edits fr...

oct 8 PeterJames
65 views

select se.OwnerUserId, u.Reputation, count(*) as Edits fr...

oct 8 PeterJames
65 views

select se.OwnerUserId, u.Reputation, count(*) as Edits fr...

oct 8 PeterJames
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
85 views

SELECT AVG(LEN(Body)) AS AvgBodyLength FROM Posts WHERE P...

oct 8 user25376965
7 views

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

oct 8
8 views

SELECT A.Id, DATEDIFF(hour, Q.CreationDate, A.CreationDate)

oct 8
8 views

SELECT t.Tagname, COUNT(*) -- count no lo pide pero para ...

oct 8
16 views

select t.TagId, count(*) as cantidad from ( select p2.Id ...

oct 8
8 views

SELECT A.Id, DATEDIFF(hour, Q.CreationDate, A.CreationDate)

oct 8
8 views

select t.TagId, count(*) as cantidad from ( select p2.Id ...

oct 8
16 views

select t.TagId, count(*) as cantidad from ( select p2.Id ...

oct 8
9 views

SELECT t.TagName, DATEDIFF(hour, preg.CreationDate, resp....

oct 8
8 views

SELECT t.TagName, COUNT(*) as n_tags FROM Posts p INNER J...

oct 8
9 views

SELECT Q.Id, DATEDIFF(hour, Q.CreationDate, A.CreationDate)

oct 8
9 views

SELECT t.TagName, DATEDIFF(hour, preg.CreationDate, resp....

oct 8
9 views

SELECT t.TagName, COUNT(*) as n_tags FROM Posts p INNER J...

oct 8
9 views

SELECT t.TagName, COUNT(*) as n_tags FROM Posts p INNER J...

oct 8
9 views

SELECT Q.Id, DATEDIFF(minute, Q.CreationDate, A.CreationD...

oct 8
9 views

SELECT Q.Id, DATEDIFF(hour, Q.CreationDate, A.CreationDate)

oct 8
9 views

SELECT P.Id, P.CreationDate, P.Score FROM Posts P WHERE P...

oct 8
9 views

SELECT P.Id, P.CreationDate, P.Score FROM Posts P WHERE P...

oct 8
9 views

with MostVoted as (select p.Id postId,answer.creationdate...

oct 8
9 views

SELECT t.TagName, DATEDIFF(hour, preg.CreationDate, resp....

oct 8
9 views

SELECT P.Id, P.CreationDate, P.Score FROM Posts P WHERE P...

oct 8
9 views

with MostVoted as (select p.Id postId,answer.creationdate...

oct 8
9 views

SELECT P.Id, P.CreationDate, P.Score FROM Posts P WHERE P...

oct 8
8 views

SELECT P.Id, P.CreationDate FROM Posts P WHERE ParentId =...

oct 8
8 views

with rtas_jav as ( select Id, OwnerUserId, ParentId from ...

oct 8
8 views

SELECT P.Id, P.CreationDate FROM Posts P WHERE ParentId <...

oct 8
8 views

SELECT t.TagName FROM Users u, Posts resp, Posts preg, Po...

oct 8
8 views

with rtas_jav as ( select Id, OwnerUserId, ParentId from ...

oct 8
9 views

with MostVoted as (select p.Id postId,answer.creationdate...

oct 8
9 views

SELECT TOP 5 t.TagName, COUNT(preg.Id) FROM Posts resps ...

oct 8
9 views

select DATEDIFF (minute , p2.CreationDate, p1.CreationDat...

oct 8
9 views

SELECT * FROM Posts Q JOIN Posts A ON (Q.Id = A.ParentId...

oct 8
9 views

SELECT p1.ParentId FROM Posts p1 WHERE p1.OwnerUserId = 5...

oct 8
9 views

SELECT t.TagName FROM Users u, Posts resp, Posts preg, Po...

oct 8
9 views

SELECT t.TagName FROM Users u, Posts resp, Posts preg, Po...

oct 8
9 views

with MostVoted as (select p.Id postId,answer.creationdate...

oct 8
9 views

select DATEDIFF (minute , p2.CreationDate, p1.CreationDat...

oct 8
9 views

SELECT t.TagName, AVG(DATEDIFF (hour, tabla_preguntas.tie...

oct 8
8 views

with MostVoted as (select p.Id postId,answer.creationdate...

oct 8
9 views

SELECT DATEDIFF(hour,p2.CreationDate, p1.CreationDate) FR...

oct 8
8 views

SELECT DATEDIFF(hour,p1.CreationDate, p2.CreationDate) FR...

oct 8
9 views

with MostVoted as (select p.Id postId,answer.creationdate...

oct 8
9 views

/* cuáles son los 5 tags sobre los cuáles más respondió J...

oct 8
9 views

select pt.TagId, count(pt.TagId) as cantidad from Users u...

oct 8
9 views

select pt.TagId, count(pt.TagId) as cantidad from Users u...

oct 8
9 views

SELECT Tags.TagName, AVG(DATEDIFF(SECOND, q.CreationDate,...

oct 8
9 views

SELECT * FROM Posts WHERE ParentId = 1 ORDER BY Posts.S...

oct 8
9 views

WITH HighestScoredAnswers AS ( SELECT a.ParentId AS Quest...

oct 8
9 views

select pt.TagId, count(pt.TagId) from Users u join posts ...

oct 8
9 views

select pt.TagId, count(pt.TagId) from Users u join posts ...

oct 8
9 views

select DATEDIFF (minute , p2.CreationDate, p1.CreationDat...

oct 8
9 views

SELECT Tags.TagName, AVG(DATEDIFF(SECOND, q.CreationDate,...

oct 8
8 views

select pt.TagId, count(pt.TagId) from Users u join posts ...

oct 8
5 views

SELECT * FROM Posts Q JOIN Posts A ON (Q.Id = A.ParentId)

oct 8
4 views

select DATEDIFF (minute , p2.CreationDate, p1.CreationDat...

oct 8
4 views

select pt.TagId, count(pt.TagId) from Users u join posts ...

oct 8
4 views

WITH HighestScoredAnswers AS ( SELECT a.ParentId AS Quest...

oct 8
4 views

select DATEDIFF (minute , p1.CreationDate, p2.CreationDat...

oct 8
3 views

select * from Users u join posts p on u.id = p.OwnerUserI...

oct 8
3 views

select p1.CreationDate-p2.CreationDate as tarda, p1.id,t....

oct 8
3 views

select * from Users u join posts p on u.id = p.OwnerUserI...

oct 8
3 views

SELECT t.Tagname FROM PostTags pt JOIN Tags t on (pt.Tagi...

oct 8
3 views

select pt.PostId, pt.TagId, p.ParentId, p.CreationDate fr...

oct 8
3 views

/* cuáles son los 5 tags sobre los cuáles más respondió J...

oct 8
3 views

select pt.PostId, pt.TagId, p.ParentId, p.CreationDate, p...

oct 8
3 views

select p1.CreationDate-p2.CreationDate as tarda from Post...

oct 8
3 views

select * from Posts p1 join Posts p2 on p1.OwnerUserId=p2...

oct 8
3 views

/* cuáles son los 5 tags sobre los cuáles más respondió J...

oct 8
3 views

select * from Users u join posts p on u.id = p.OwnerUserI...

oct 8
4 views

SELECT p1.ParentId, p1.OwnerUserId FROM Posts p1 WHERE p1...

oct 8
3 views

select * from Users u join posts p on u.id = p.OwnerUserI...

oct 8
3 views

/* cuáles son los 5 tags sobre los cuáles más respondió J...

oct 8

30 50 100 per page

2,259,815

queries

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

13k questions

39k answers

78k comments

391 tags

oct 5 most recent