Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

6 views

SELECT Id, Title, ViewCount FROM dbo.Posts P WHERE P.Id =...

dec 2 Larnu
6 views

SELECT * FROM dbo.Posts P WHERE P.Id = ##PostId:int##

dec 2 Larnu
51 views

SELECT TOP 200 * FROM Comments ORDER BY Score ASC, Text A...

dec 2 Pet237d160.The160.Spring160.Wizard
51 views

SELECT TOP 200 * FROM Comments ORDER BY Score DESC, Text ...

dec 2 Pet237d160.The160.Spring160.Wizard
24 views

select COUNT(*) from Posts;

dec 2
26 views

select COUNT(id) from Users;

dec 2
14 views

select COUNT(*) from Users;

dec 2
26 views

select COUNT(*) from Users;

dec 2
24 views

select COUNT(*) from Users;

dec 2
15 views

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

dec 2
26 views

SELECT U.Id AS UserId, DATEDIFF(DAY, U.CreationDate, GETD...

dec 2
27 views

SELECT U.Id AS UserId, U.Reputation, DATEDIFF(DAY, U.Crea...

dec 2
127 views

WITH SortedComments AS ( SELECT PostId, Text AS Comment, ...

dec 2 Aleksejs.Zareckis
127 views

WITH SortedComments AS ( SELECT PostId, Text AS Comment, ...

dec 2 Aleksejs.Zareckis
127 views

WITH SortedComments AS ( SELECT PostId, Text AS Comment, ...

dec 2 Aleksejs.Zareckis
15 views

select t.tagName, e.body as 'Excerpt', w.body as 'WikiBody'

dec 2
75 views

WITH PostsSelected AS( SELECT pt.PostId FROM PostTags pt ...

dec 2 Aleksejs.Zareckis
75 views

WITH PostsSelected AS( SELECT pt.PostId FROM PostTags pt ...

dec 2 Aleksejs.Zareckis
274 views

SELECT * FROM Posts p JOIN PostTags pt ON p.Id = pt.PostI...

dec 2 Aleksejs.Zareckis
75 views

SELECT pt.PostId FROM PostTags pt JOIN Tags t ON pt.TagId...

dec 2 Aleksejs.Zareckis
75 views

SELECT pt.PostId FROM PostTags pt JOIN Tags t ON pt.TagId...

dec 2 Aleksejs.Zareckis
75 views

SELECT pt.PostId FROM PostTags pt JOIN Tags t ON pt.TagId...

dec 2 Aleksejs.Zareckis
75 views

SELECT t.Id from Tags t WHERE t.TagName in ('css','html')...

dec 2 Aleksejs.Zareckis
40 views

user

dec 2
25 views

user

dec 2
40 views

user

dec 2
13 views

WITH FilteredPosts AS ( SELECT p.Id, p.Title, p.Body, p.C...

dec 2
27 views

SELECT TOP 1000 u.id AS UserId, u.Reputation, u.CreationD...

dec 2
27 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
27 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
27 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
26 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
27 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
14 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
27 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
26 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
27 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
27 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
27 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
27 views

SELECT TOP 500 u.id AS UserId, u.Reputation, u.CreationDa...

dec 2
14 views

select top 3000 tagname from tags Order by "count" DESC;

dec 2
14 views

select users.id, DATEDIFF(ss, users.creationdate, CURRENT...

dec 2
27 views

select users.id, DATEDIFF(ss, users.creationdate, CURRENT...

dec 2
26 views

select users.id, DATEDIFF(ss, users.creationdate, CURRENT...

dec 2
27 views

SELECT Top 500 p.id AS PostId, p.PostTypeId, p.Score, p.c...

dec 2
26 views

SELECT Top 500 p.id AS PostId, p.PostTypeId, p.Score, p.c...

dec 2
26 views

SELECT TOP 200 p.id AS PostId, p.PostTypeId, p.Score, p.c...

dec 2
26 views

SELECT TOP 200 p.id AS PostId, p.PostTypeId, p.Score, p.c...

dec 2
14 views

select p.id as PostId, p.PostTypeId, p.Score, p.closeddate,

dec 2
26 views

select p.id as PostId, p.PostTypeId, p.Score, p.closeddate,

dec 2
26 views

select p.id as PostId, p.PostTypeId, p.Score, p.closeddate,

dec 2
26 views

select p.id as PostId, p.PostTypeId, p.Score, p.closeddate,

dec 2
27 views

select p.id as PostId, p.PostTypeId, p.Score, p.closeddate,

dec 2
14 views

SELECT Users.Id AS UserId, Users.DisplayName, Users.Reput...

dec 2
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
27 views

SELECT title,concat('https://stackoverflow.com/questions/...

dec 2
145 views

Indexes for SO

dec 2 davidalayachew
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
18 views

Select SUM(score) AS total_score from Posts WHERE score ...

dec 2
567 views

SELECT p.Id, p.Tags, p.Title, p.Body as Questions_Body, p...

dec 2 jon.doe46307
15 views

SELECT title,concat('https://stackoverflow.com/questions/...

dec 2
27 views

SELECT title,concat('https://stackoverflow.com/questions/...

dec 2
16 views

SELECT u.DisplayName, u.Id, u.Reputation, u.CreationDate ...

dec 2
274 views

SELECT PostId, Text AS Comment, CreationDate, ROW_NUMBER(...

dec 2 Aleksejs.Zareckis
127 views

WITH SortedComments AS ( SELECT PostId, Text AS Comment, ...

dec 2 Aleksejs.Zareckis
127 views

WITH SortedComments AS ( SELECT PostId, Text AS Comment, ...

dec 2 Aleksejs.Zareckis
15 views

SELECT u.DisplayName, u.Id, u.Reputation, u.CreationDate ...

dec 2
274 views

select postId,count(1) from comments group by postid

dec 2 Aleksejs.Zareckis
274 views

select * from comments

dec 2 Aleksejs.Zareckis
274 views

select postId,count(1) from comments group by postid

dec 2 Aleksejs.Zareckis
15 views

SELECT Id AS [Question ID], Title AS [Question Title], Bo...

dec 2
274 views

SELECT count(1) FROM PostTags t where tagid = 600

dec 2 Aleksejs.Zareckis
274 views

SELECT * FROM Tags t

dec 2 Aleksejs.Zareckis
274 views

SELECT tagName,count(1) FROM Tags t group by tagname havi...

dec 2 Aleksejs.Zareckis
274 views

SELECT tagName,count(1) FROM Tags t group by tagname

dec 2 Aleksejs.Zareckis
40 views

WITH RecentPosts AS ( SELECT p.OwnerUserId, COUNT(*) AS P...

dec 2 jon.doe45850
40 views

WITH UserActivity AS ( SELECT u.Id AS UserId, u.DisplayNa...

dec 2 jon.doe45850
40 views

WITH UserActivity AS ( SELECT u.Id AS UserId, u.DisplayNa...

dec 2 jon.doe45850
274 views

SELECT * FROM Tags t

dec 2 Aleksejs.Zareckis
274 views

SELECT * FROM Tags t

dec 2 Aleksejs.Zareckis
274 views

SELECT DISTINCT pt.PostId FROM Tags t JOIN PostTags pt ON...

dec 2 Aleksejs.Zareckis
41 views

SELECT TOP 1000 * FROM Users ORDER BY RAND()

dec 2 jon.doe45838
41 views

SELECT TOP 1000 * FROM Users ORDER BY RAND()

dec 2 jon.doe45838
274 views

SELECT pt.PostId, t.TagName FROM Tags t JOIN PostTags pt ...

dec 2 Aleksejs.Zareckis
41 views

SELECT TOP 200 * FROM Users ORDER BY RAND()

dec 2 jon.doe45838
274 views

WITH VotesMods AS ( SELECT PostId, SUM(CASE WHEN vt.Name ...

dec 2 Aleksejs.Zareckis
127 views

WITH SortedComments AS ( SELECT PostId, Text AS Comment, ...

dec 2 Aleksejs.Zareckis
127 views

WITH SortedComments AS ( SELECT PostId, Text AS Comment, ...

dec 2 Aleksejs.Zareckis
274 views

WITH Combos AS( SELECT pt.PostId, STRING_AGG(t.TagName,',...

dec 2 Aleksejs.Zareckis
274 views

WITH Combos AS( SELECT pt.PostId, STRING_AGG(t.TagName,',...

dec 2 Aleksejs.Zareckis
274 views

WITH Combos AS( SELECT pt.PostId, STRING_AGG(t.TagName,',...

dec 2 Aleksejs.Zareckis
274 views

WITH Combos AS( SELECT pt.PostId, STRING_AGG(t.TagName,',...

dec 2 Aleksejs.Zareckis
274 views

WITH Combos AS( SELECT pt.PostId, STRING_AGG(t.TagName,',...

dec 2 Aleksejs.Zareckis
274 views

WITH Combos AS( SELECT pt.PostId, STRING_AGG(t.TagName,',...

dec 2 Aleksejs.Zareckis
274 views

WITH Combos AS( SELECT pt.PostId, STRING_AGG(t.TagName,',...

dec 2 Aleksejs.Zareckis
274 views

WITH Combos AS( SELECT pt.PostId, STRING_AGG(t.TagName,',...

dec 2 Aleksejs.Zareckis
274 views

SELECT pt.PostId, STRING_AGG(t.TagName,',') WITHIN GROUP ...

dec 2 Aleksejs.Zareckis
15 views

Select id, score from Posts WHERE score < 100

dec 2
274 views

SELECT STRING_AGG(t.TagName,' '),p.Id FROM Posts p JOIN P...

dec 2 Aleksejs.Zareckis
274 views

SELECT STRING_AGG(t.TagName,''),p.Id FROM Posts p JOIN Po...

dec 2 Aleksejs.Zareckis
274 views

SELECT STRING_AGG(t.TagName,''),p.Id FROM Posts p JOIN Po...

dec 2 Aleksejs.Zareckis

30 50 100 per page