Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

6 views

select string_agg(name,'","') from voteTypes;

jan 29
6 views

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

jan 29
6 views

select string_agg(name,'","') from voteTypes;

jan 29
6 views

select string_agg(name,',') from voteTypes;

jan 29
7 views

select Tags from Posts;

jan 29
7 views

select * from voteTypes;

jan 29
7 views

select * from postTypes;

jan 29
7 views

select count(*) from postTypes;

jan 29
7 views

select count(*) from users;

jan 29
7 views

select count(*) from posts;

jan 29
7 views

select count(*) from posts;

jan 29
7 views

select count(*) from posts;

jan 29
7 views

select count(*) from posts;

jan 29
7 views

select count(*) from posts;

jan 29
6 views

select count(*) from posts;

jan 29
6 views

select count(*) from posts;

jan 29
6 views

select count(*) from posts;

jan 29
10 views

select count(se.id) from SuggestedEdits se inner join rev...

jan 29
10 views

select * from Tags;

jan 29
7 views

select * from Tags;

jan 29
13 views

select count(distinct OwnerUserId) from Posts where Post...

jan 29
19 views

Top 100 rated SO users from Ahmedabad

jan 29
19 views

Top 100 rated SO users from Ahmedabad

jan 29
19 views

Top 100 rated SO users from Ahmedabad

jan 29
13 views

select * from posts;

jan 29
13 views

select * from posts

jan 29
16 views

SELECT Id AS [Post Link], (SELECT MAX(v) FROM (VALUES (Cl...

jan 28
13 views

SELECT * FROM Tags WHERE ExcerptPostId IS NULL ORDER BY C...

jan 28 peterh - PLEASE DELETE THIS ACCOUNT
12 views

select t.tagName, [COUNT], e.body as 'Excerpt', w.body as...

jan 28
1

11k views

Search comments

jan 28 Dour High Arch
12 views

select t.id, t.tagName, [COUNT], e.body as 'Excerpt', w.b...

jan 28
12 views

select t.id, t.tagName, [COUNT], e.body as 'Excerpt', w.b...

jan 28
12 views

select t.id, t.tagName, [COUNT], e.body as 'Excerpt', w.b...

jan 28
13 views

select t.tagName, [COUNT], e.body as 'Excerpt', w.body as...

jan 28
12 views

select t.tagName, [COUNT], e.body as 'Excerpt', w.body as...

jan 28
12 views

select t.tagName, [COUNT], e.body as 'Excerpt', w.body as...

jan 28
12 views

select t.tagName, [COUNT], e.body as 'Excerpt', w.body as...

jan 28
13 views

Select TagName From Tags

jan 28
12 views

CREATE TABLE #yt ( [Store] int, [Week] int, [xCount] int );

jan 28
12 views

CREATE TABLE #yt ( [Store] int, [Week] int, [xCount] int );

jan 28
12 views

CREATE TABLE #yt ( [Store] int, [Week] int, [xCount] int );

jan 28
13 views

CREATE TABLE #yt ( [Store] int, [Week] int, [xCount] int );

jan 28
13 views

CREATE TABLE #yt ( [Store] int, [Week] int, [xCount] int );

jan 28
13 views

CREATE TABLE #yt ( [Store] int, [Week] int, [xCount] int );

jan 28
13 views

CREATE TABLE #yt ([Store] int, [Week] int, [xCount] int) ;

jan 28
13 views

CREATE TABLE #yt ([Store] int, [Week] int, [xCount] int) ;

jan 28
13 views

CREATE TABLE #yt ([Store] int, [Week] int, [xCount] int) ;

jan 28
1

14 views

WITH ANSWERS AS ( SELECT sum(case when AnswerCount>0 the...

jan 28
13 views

WITH ANSWERS AS ( SELECT sum(case when AnswerCount>0 the...

jan 28
13 views

WITH ANSWERS AS ( SELECT sum(case when AnswerCount>0 the...

jan 28
13 views

/*WITH ANSWERS AS ( SELECT sum(case when AnswerCount>0 t...

jan 28
14 views

WITH ANSWERS AS ( SELECT Id, sum(case when AnswerCount>0...

jan 28
13 views

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

jan 28
12 views

WITH ANSWERS AS ( SELECT SUM(AnswerCount) TOTAL_ANSWERS ...

jan 28
14 views

WITH ANSWERS AS ( SELECT SUM(AnswerCount) TOTAL_ANSWERS ...

jan 28
13 views

WITH ANSWERS AS ( SELECT SUM(AnswerCount) TOTAL_ANSWERS ...

jan 28
13 views

WITH ANSWERS AS ( SELECT SUM(AnswerCount) TOTAL_ANSWERS ...

jan 28
13 views

WITH ANSWERS AS ( SELECT SUM(AnswerCount) TOTAL_ANSWERS ...

jan 28
1

14 views

WITH ANSWERS AS ( SELECT SUM(AnswerCount) TOTAL_ANSWERS ...

jan 28
11 views

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

jan 28
21 views

Task Step 1 - Explore and Tasks

jan 28
10 views

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

jan 28
10 views

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

jan 28
10 views

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

jan 28
10 views

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

jan 28
20 views

Task Step 1 - Explore and Tasks

jan 28
21 views

Task Step 1 - Explore and Tasks

jan 28
10 views

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

jan 28
13 views

SELECT * FROM Posts WHERE CreationDate > '2022-01-01' Ord...

jan 28 jon.doe34472
12 views

SELECT distinct p.Id AS [Post Link], p.CreationDate FROM ...

jan 28 Juraj
12 views

SELECT p.Id AS [Post Link], p.CreationDate FROM Posts AS ...

jan 28 Juraj
23 views

2022 ViewCount

jan 28 jon.doe34472
23 views

Get data

jan 28
21 views

Get data

jan 28
22 views

Get data

jan 28
21 views

Get data

jan 28
23 views

Get data

jan 28
23 views

Number of posts in Math Stack Overflow that are over the 30k soft character limit

jan 28
13 views

SELECT TOP 5 Input.Id [User Link], Input.Id, u.Reputation...

jan 28 LasseG
13 views

SELECT TOP 5 Input.Id [User Link], Input.Id, SUM(Daily_Sc...

jan 28 LasseG
13 views

SELECT TOP 5 Input.Id [User Link], SUM(Daily_Score) FROM ...

jan 28 LasseG
13 views

SELECT Input.Id [User Link], SUM(Daily_Score) FROM ( SELE...

jan 28 LasseG
13 views

SELECT Input.Id, SUM(Daily_Score) FROM ( SELECT TOP 100 u...

jan 28 LasseG
37 views

SELECT TOP 100 u.Id [User Link], DATEADD(day, DATEDIFF(da...

jan 28 LasseG
37 views

SELECT TOP 100 u.Id [User Link], DATEADD(day, DATEDIFF(da...

jan 28 LasseG
13 views

Select VoteTypeId, COUNT(Id) FROM Votes WHERE CreationDat...

jan 28 LasseG
13 views

Select VoteTypeId, COUNT(Id) FROM Votes GROUP BY VoteTypeId

jan 28 LasseG
13 views

select count(*), count(distinct(OwnerUserId)) from Posts ...

jan 28
15 views

SELECT * FROM (SELECT TOP 1 create_date AS [Voted On], -...

jan 28 Martijn Pieters
14 views

SELECT * FROM (SELECT TOP 1 create_date AS [Voted On], -...

jan 28 Martijn Pieters
14 views

SELECT * FROM (SELECT TOP 1 create_date AS [Voted On], -...

jan 28 Martijn Pieters
14 views

select count(*), count(distinct(OwnerUserId)) from Posts;

jan 28
13 views

select count(*), count(distinct(OwnerUserId)) from Posts;

jan 28
14 views

SELECT * FROM (SELECT TOP 1 create_date AS [Voted On], -...

jan 28 Martijn Pieters
14 views

SELECT TOP 1 create_date AS [Voted On], -1 AS [User Link]...

jan 28 Martijn Pieters
26 views

Number of posts in Math Stack Overflow that are over the 30k soft character limit

jan 28
23 views

Number of posts in Math Stack Overflow that are over the 30k soft character limit

jan 28
25 views

Number of posts in Math Stack Overflow that are over the 30k soft character limit

jan 28
27 views

Number of posts in Stack Overflow that are over the 30k soft character limit

jan 28
16 views

SELECT TOP 1 create_date, -1 FROM sys.databases WHERE nam...

jan 28 Martijn Pieters
24 views

Number of posts in Stack Overflow that are over the 30k soft character limit

jan 28
27 views

Number of posts in Stack Overflow that are over the 30k soft character limit

jan 28
25 views

Number of posts in Math Stack Overflow that are over the 30k soft character limit

jan 28
26 views

Number of posts in Math Stack Overflow that are over the 30k soft character limit

jan 28
23 views

Number of posts in Math Stack Overflow that are over the 30k soft character limit

jan 28
15 views

select count(*) as count from posts where postTypeId = 1

jan 28
15 views

select top 1 create_date from sys.databases where name no...

jan 28 Martijn Pieters
17 views

WITH top_users AS (SELECT TOP 10 ownerUserId, SUM(score) ...

jan 28
15 views

WITH top_users AS (SELECT TOP 10 ownerUserId, SUM(score) ...

jan 28
21 views

SELECT Location, COUNT(*) FROM Users WHERE LOWER(Location...

jan 28 Roman R.
14 views

WITH top_users AS (SELECT TOP 10 ownerUserId, SUM(score) ...

jan 28
14 views

select * from sys.databases order by create_date desc

jan 28 Martijn Pieters
23 views

example

jan 28
14 views

select create_date , name from sys.databases order by cr...

jan 28 Martijn Pieters
21 views

SELECT Location, COUNT(*) FROM Users WHERE LOWER(Location...

jan 28 Roman R.
21 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.
21 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.
1

28 views

Who bookmarked a post?

jan 28 Martijn Pieters
14 views

select top 100 *, concat('https://stackoverflow.com/users...

jan 28
39 views

SELECT u.Id [User Link], u.Reputation, u.CreationDate, u....

jan 28 LasseG
24 views

example

jan 28
14 views

WITH top_users AS (SELECT TOP 10 ownerUserId, SUM(score) ...

jan 28
25 views

Details by Tag

jan 28 bwest
23 views

Details by Tag

jan 28 bwest
13 views

SELECT * FROM Posts

jan 28
21 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.
21 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.

30 50 100 per page