Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

DECLARE @UserId int = 3290339 SELECT PostId As [Post Lin...

oct 1
0 views

SELECT COUNT(DISTINCT u.id) FROM users AS u LEFT JOIN pos...

oct 1
2 views

WITH users_posts AS ( SELECT DISTINCT u.id, COUNT(*) AS p...

oct 1
3 views

WITH users_posts AS ( SELECT DISTINCT u.id, COUNT(*) AS p...

oct 1
5 views

WITH users_posts AS ( SELECT u.id, COUNT(*) AS posts_amount

oct 1
5 views

SELECT Id,PostTypeId,CreationDate,Score,ViewCount, Tags,A...

oct 1
7 views

SELECT Id,PostTypeId,CreationDate,Score,ViewCount, Tags,A...

oct 1
6 views

SELECT * FROM Posts WHERE YEAR(CreationDate) = 2019;

oct 1
6 views

SELECT TOP 50 * FROM Posts WHERE YEAR(CreationDate) = 2019;

oct 1
6 views

SELECT * FROM Posts WHERE YEAR(CreationDate) = 2019;

oct 1
6 views

WITH asked AS ( SELECT u.* FROM users AS u JOIN posts AS ...

oct 1
8 views

WITH asked AS ( SELECT u.* FROM users AS u JOIN posts AS ...

oct 1
8 views

SELECT * FROM posttypes

oct 1
8 views

WITH asked AS ( SELECT u.* FROM users AS u JOIN posts AS ...

oct 1
8 views

WITH asked AS ( SELECT u.* FROM users AS u JOIN posts AS ...

oct 1
9 views

SELECT TOP(100) p.Id AS [Post Link] , p.CreationDate AS [...

oct 1
9 views

SELECT t.tagname, AVG(DATEDIFF(day,p.creationdate, p.clos...

oct 1
9 views

SELECT t.tagname, AVG(DATEDIFF(day, p.closeddate, p.creat...

oct 1
10 views

SELECT t.tagname, AVG(DATEDIFF(hour, p.closeddate, p.crea...

oct 1
10 views

SELECT TOP(100) p.Id AS [Post Link] , p.CreationDate AS [...

oct 1
10 views

SELECT TOP(100) p.Id AS [Post Link] , p.CreationDate AS [...

oct 1
10 views

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

oct 1
10 views

SELECT q.OwnerUserId as [User Link], COUNT(q.OwnerUserId)...

oct 1 Dharman
10 views

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

oct 1
10 views

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

oct 1
10 views

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

oct 1
10 views

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

oct 1
10 views

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

oct 1
10 views

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

oct 1
10 views

SELECT COUNT(*), MIN(CreationDate) AS min_date, MAX(Creat...

oct 1
10 views

SELECT TOP 10 t.tagname FROM tags AS t JOIN posttags AS p...

oct 1
10 views

SELECT TOP 10 * FROM tags

oct 1
10 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
10 views

SELECT TOP 460 /* Need to look at multiple tables unioned...

oct 1
10 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
11 views

SELECT TOP 440 /* Need to look at multiple tables unioned...

oct 1
11 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
11 views

SELECT TOP 10* FROM Posts WHERE CreationDate >= 2019;

oct 1
11 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
11 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
10 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
10 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
10 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
10 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
9 views

SELECT p.Id AS [Post Link] , p.CreationDate AS [Date] , p...

oct 1
11 views

SELECT TOP 10* FROM Posts;

oct 1
11 views

SELECT TOP 420 /* Need to look at multiple tables unioned...

oct 1
11 views

SELECT PostTypeId, COUNT(*) as NrOfPosts FROM posts GROUP...

oct 1
11 views

SELECT PostTypeId, COUNT(*) as NrOfPosts FROM posts GROUP...

oct 1
11 views

SELECT TOP 400 /* Need to look at multiple tables unioned...

oct 1
13 views

SELECT TOP 10 * FROM Posts ORDER BY CreationDate;

oct 1
13 views

SELECT TOP 10 * FROM Posts;

oct 1
13 views

SELECT * FROM Posts;

oct 1
13 views

SELECT TOP 375 /* Need to look at multiple tables unioned...

oct 1
12 views

SELECT * FROM tags;

oct 1
12 views

SELECT * FROM tags;

oct 1
12 views

SELECT * FROM tags;

oct 1
13 views

SELECT * FROM tags;

oct 1
13 views

SELECT * FROM tags;

oct 1
13 views

SELECT * FROM tags;

oct 1
11 views

SELECT * FROM tags;

oct 1
11 views

SELECT * FROM tags;

oct 1
11 views

SELECT * FROM tags;

oct 1
11 views

SELECT * FROM tags;

oct 1
6 views

SELECT * FROM tags;

oct 1
6 views

SELECT * FROM tags;

oct 1
6 views

SELECT * FROM tags;

oct 1
7 views

SELECT * FROM tags;

oct 1
5 views

SELECT * FROM tags;

oct 1
29 views

Votes per post over the years

oct 1 Polygnome
11 views

SELECT TOP 360 /* Need to look at multiple tables unioned...

oct 1
29 views

Votes per post over the years

oct 1 Polygnome

30 50 100 per page

1,583,390

queries

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

294 questions

498 answers

1.4k comments

83 tags

sep 27 most recent