Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

SELECT id from posts;

sep 20
1 view

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

sep 20
4 views

select tags from posts where tags is not null;

sep 20
2 views

select tags from posts;

sep 20
4 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
26 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
26 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

30 50 100 per page

2,253,243

queries

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

2.2k questions

4.3k answers

11k comments

237 tags

sep 13 most recent