Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

select tags from posts where tags is not null;

sep 20
1 view

select tags from posts;

sep 20
0 views

select tags from posts;

sep 20
103 views

select top 5 tg, count(postid) from ( select postid, stri...

sep 20 Janis123
134 views

select top 1 tg, count(postid) from ( select postid, stri...

sep 20 Janis123
60 views

select top(5) tag_combo, count(1) from (select pttg.PostI...

sep 20 Janis123
6 views

SELECT COUNT(*) AS num_posts, MIN(CreationDate) AS min_da...

sep 20
25 views

1. Most posts

sep 20
103 views

with calendar as ( select TOP(DATEDIFF(day, '2023-12-31',...

sep 20 Janis123
9 views

select top 15 owneruserid, count(*) as postcount from posts

sep 20
25 views

1. Most posts

sep 20
60 views

select cast(p.creationdate as date) as dt, pt.tagid, sum(...

sep 20 Janis123
9 views

SELECT ind.*, t.name FROM sys.indexes ind INNER JOIN sy...

sep 20 Arnoscht
10 views

select top 20 owneruserid, rank() over (order by count(ac...

sep 20
9 views

SELECT ind.*, t.name FROM sys.indexes ind INNER JOIN sy...

sep 20 Arnoscht
10 views

SELECT TableName = t.name, IndexName = ind.name, IndexId ...

sep 20 Arnoscht
10 views

select * from sys.indexes

sep 20 Arnoscht
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
103 views

select top(5) ptg.TagId from Posts pst join PostTags ptg ...

sep 20 Janis123
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
134 views

select top 3 c.postid, count(1) from comments c inner joi...

sep 20 Janis123
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
134 views

select * from ( select top 10 postid from votes where vot...

sep 20 Janis123
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
134 views

select * from posts where id in ( select postid from post...

sep 20 Janis123
40 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
40 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
26 views

SELECT top 1000 * FROM POSTS where id>78621782 order by id

sep 20 Arnoscht
25 views

SELECT top 1000 * FROM POSTS where id>78721782 order by id

sep 20 Arnoscht
25 views

SELECT top 1000 * FROM POSTS where id>78821782 order by id

sep 20 Arnoscht
25 views

SELECT top 1000 * FROM POSTS where id>78521782 order by id

sep 20 Arnoscht
26 views

SELECT top 1000 * FROM POSTS where id>78021782 order by id

sep 20 Arnoscht
25 views

SELECT top 1000 * FROM POSTS where id>77921782 order by id

sep 20 Arnoscht
26 views

SELECT top 1000 * FROM POSTS where id>77921782 order by id

sep 20 Arnoscht
26 views

SELECT * FROM POSTS where id>77921782 order by id

sep 20 Arnoscht
26 views

SELECT * FROM POSTS where id>77921782 order by id

sep 20 Arnoscht
26 views

SELECT * FROM POSTS where id=77921782

sep 20 Arnoscht
25 views

SELECT * FROM POSTS where id=78921782

sep 20 Arnoscht
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
114 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
40 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
114 views

SELECT id FROM POSTS ORDER BY ID DESC

sep 20 Arnoscht
40 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 Arnoscht
21 views

% of posts with no comments

sep 20
20 views

% of posts with no comments

sep 20
11 views

SELECT MAX(CREATIONDATE) FROM POSTS

sep 20 jon.doe45742
133 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
25 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
26 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
26 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
26 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
26 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
25 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
26 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
25 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
25 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
25 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
26 views

SELECT DATEADD(day,-90,GETDATE())

sep 20 jon.doe45742
134 views

select count(distinct postid) from PostTags s where TagId...

sep 20 Janis123
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
134 views

select count(distinct postid) from PostTags where TagId i...

sep 20 Janis123
134 views

WITH TOP_TAGS AS ( SELECT TOP 5 P1.TagId AS 'TagId1' ,P2....

sep 20 Janis123
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
60 views

select top(5) tag_combo, count(1) from (select pttg.PostI...

sep 20 Janis123
134 views

WITH TOP_TAGS AS ( SELECT TOP 5 P1.TagId AS 'TagId1' ,P2....

sep 20 Janis123
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
60 views

select * from Tags where id in (2,4)

sep 20 Janis123
60 views

select * from Tags

sep 20 Janis123
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
60 views

select top(5) tag_combo, count(1) from (select pttg.PostI...

sep 20 Janis123
134 views

WITH TOP_TAGS AS ( SELECT TOP 5 P1.TagId AS 'TagId1' ,P2....

sep 20 Janis123
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
134 views

WITH TOP_TAGS AS ( SELECT TOP 1 P1.TagId AS 'TagId1' ,P2....

sep 20 Janis123
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
134 views

SELECT CONVERT (date, P.CreationDate), T.TagName, Count(*...

sep 20 Janis123
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
60 views

SELECT TOP 5 PT.TagId FROM PostTags PT INNER JOIN Posts P...

sep 20 Janis123
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
193 views

/* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...

sep 20 jon.doe45742
19 views

% of posts with no comments

sep 20
134 views

select PostId, count(1) from ( SELECT C1.PostId ,C1.Text ...

sep 20 Janis123
134 views

SELECT C1.PostId ,C1.Text FROM Comments C1 LEFT JOIN Comm...

sep 20 Janis123
60 views

select PostId, 'UpMod' x from (select vt.PostId ,rank () ...

sep 20 Janis123
103 views

select * from VoteTypes

sep 20 Janis123
103 views

with x as ( select id, type, count(1) cnt from ( select 1...

sep 20 Janis123
103 views

with x as ( select id, type, count(1) cnt from ( select 1...

sep 20 Janis123
103 views

with x as ( select id, type, count(1) cnt from ( select 1...

sep 20 Janis123
103 views

with x as ( select id, type, count(1) cnt from ( select 1...

sep 20 Janis123
103 views

with x as ( select id, type, count(1) cnt from ( select 1...

sep 20 Janis123
103 views

with x as ( select id, count(1) cnt from ( select 1 id, '...

sep 20 Janis123
103 views

with x as ( select 1 id, 'upmod' type union all select 1,...

sep 20 Janis123
133 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
133 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
133 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
133 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
134 views

WITH DIS_VOTES AS ( SELECT DISTINCT V.PostID, V.VoteTypeI...

sep 20 Janis123
133 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
133 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
25 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
26 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
193 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742
134 views

SELECT top 5 P.id, count(1) FROM Posts P INNER JOIN PostT...

sep 20 Janis123
134 views

SELECT top 5 P.id, count(1) FROM Posts P INNER JOIN PostT...

sep 20 Janis123
193 views

WITH POCET_UZIV AS( --POCET UZIVATELU CELKEM SELECT COUNT...

sep 20 jon.doe45742

30 50 100 per page

2,253,241

queries

Q&A about the site for serious players and enthusiasts of chess

415 questions

567 answers

1.2k comments

82 tags

jul 16 most recent