Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

27 views

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

oct 14 Juraj
33 views

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

oct 14 Juraj
33 views

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

oct 14 Juraj
33 views

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

oct 14 Juraj
33 views

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

oct 14 Juraj
27 views

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

oct 14 Juraj
27 views

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

oct 14 Juraj
27 views

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

oct 14 Juraj
33 views

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

oct 14 Juraj
33 views

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

oct 14 Juraj
10 views

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

oct 14
10 views

SELECT TOP 100 Id, Title, CreationDate, Score FROM Posts ...

oct 14
138 views

select * from ( select * from Posts order by Id desc OFFS...

oct 14 async.await
138 views

select * from ( select * from Posts order by Id desc OFFS...

oct 14 async.await
138 views

select * from ( select * from Posts order by Id desc OFFS...

oct 14 async.await
138 views

select * from ( select top 20 * from Posts order by Id desc

oct 14 async.await
138 views

select * from ( select top 10000 * from Posts order by Id...

oct 14 async.await
138 views

select Title from ( select top 10000 * from Posts order b...

oct 14 async.await
138 views

select * from ( select top 10000 * from Posts order by Id...

oct 14 async.await
138 views

select Title from ( select top 10000 * from Posts order b...

oct 14 async.await
138 views

select * from ( select top 10000 * from Posts order by Id...

oct 14 async.await
138 views

select * from ( select top 10000 * from Posts order by Id...

oct 14 async.await
138 views

select * from ( select top 100 * from Posts order by Id d...

oct 14 async.await
138 views

select * from ( select top 100 * from Posts order by Id d...

oct 14 async.await
138 views

select * from ( select top 100 * from Posts order by Id d...

oct 14 async.await
138 views

select * from ( select top 20 * from Posts order by Id desc

oct 14 async.await
138 views

select * from ( select top 20 * from Posts order by Id desc

oct 14 async.await
138 views

select top 20 * from Posts order by Id desc

oct 14 async.await
29 views

select id, title, body from posts where id in (32333312 ,...

oct 14 khairul.alam44847
29 views

select * from posts where id in (32333312 ,33695244 ,3394...

oct 14 khairul.alam44847
29 views

select * from posts where id in (32333312 ,33695244 ,3394...

oct 14 khairul.alam44847
21 views

SELECT STRING_AGG(t.TagName, ', ') AS Tags, COUNT(pt.TagI...

oct 14
22 views

SELECT STRING_AGG(t.TagName, ', ') AS Tags, count(pt.Tag...

oct 14
22 views

SELECT STRING_AGG(t.TagName, ', ') AS Tags, count(pt.Tag...

oct 14
22 views

SELECT STRING_AGG(t.TagName, ', ') AS Tags, p.OwnerUserId,

oct 14
10 views

SELECT p.Id AS PostId, p.Title, STRING_AGG(t.TagName, ', ...

oct 14
22 views

SELECT p.Id AS PostId, p.Title, STRING_AGG(t.TagName, ', ...

oct 14
22 views

SELECT p.Id AS PostId, p.Title, STRING_AGG(t.TagName, ', ...

oct 14
22 views

SELECT p.Id AS PostId, p.Title, STRING_AGG(t.TagName, ', ...

oct 14
21 views

SELECT p.Id AS PostId, p.Title, STRING_AGG(t.TagName, ', ...

oct 14
23 views

SELECT (COUNT(*) - COUNT(c.Id)) * 100.0 / COUNT(*) AS Per...

oct 14
11 views

SELECT p.Id AS PostId, p.Title, STRING_AGG(t.TagName, ', ...

oct 14
23 views

SELECT p.Id AS PostId, p.Title, STRING_AGG(t.TagName, ', ...

oct 14
11 views

select * from posts where id in (51425439, 59240668, 5931...

oct 14
11 views

select * from posts where id in (38399401, 40710687, 4113...

oct 14
11 views

select * from posts where id in (38719649, 38757813, 4109...

oct 14
11 views

select * from posts where id in (38719649, 38757813, 4109...

oct 14
11 views

select * from posts where id in (32333312, 33695244, 3394...

oct 14
12 views

select * from Users WHERE (emailhash IS NULL OR emailhash...

oct 13 MikeLikesDatabases
11 views

select * from Users WHERE (location IS NULL OR location =...

oct 13 MikeLikesDatabases
11 views

select * from Users where location is null;

oct 13 MikeLikesDatabases
11 views

select * from Users where reputation is null;

oct 13 MikeLikesDatabases
11 views

select * from Users where reputation is null;

oct 13 MikeLikesDatabases
12 views

with pre as ( select u.Id as userId, u.DisplayName, p.id ...

oct 13 MikeLikesDatabases
11 views

with pre as ( select u.Id as userId, u.DisplayName, p.id ...

oct 13 MikeLikesDatabases
12 views

with pre as ( select u.Id as userId, u.DisplayName, p.id ...

oct 13 MikeLikesDatabases
11 views

select TOP(5) p.id, p.viewcount from posts p where viewco...

oct 13 MikeLikesDatabases
11 views

select count(1) from posts where viewcount is null;

oct 13 MikeLikesDatabases
12 views

with pre as ( select u.Id as userId, u.DisplayName, p.id ...

oct 13 MikeLikesDatabases
11 views

select u.Id, u.DisplayName, p.id, p.Title, p.ViewCount, p...

oct 13 MikeLikesDatabases
11 views

WITH RecentPosts AS ( SELECT po.OwnerUserId, po.Title, po...

oct 13
12 views

WITH pre_over_10 AS ( select u.id as UserId from Users u ...

oct 13 MikeLikesDatabases
11 views

WITH pre_over_10 AS ( select u.id as UserId from Users u ...

oct 13 MikeLikesDatabases
11 views

WITH pre AS( select u.id as UserId from Users u join Post...

oct 13 MikeLikesDatabases
12 views

select Count(u.id) from Users u join Posts p ON p.OwnerUs...

oct 13 MikeLikesDatabases
11 views

select u.id, u.displayname, p.id, p.Title from Users u jo...

oct 13 MikeLikesDatabases
12 views

select u.id, COUNT(p.id) from Users u join Posts p ON p.O...

oct 13 MikeLikesDatabases
11 views

select u.id, COUNT(p.id) from Users u join Posts p ON p.O...

oct 13 MikeLikesDatabases
12 views

select ROUND(((CAST(SUM(CASE WHEN p.ID IS NULL THEN 1 ELS...

oct 13 MikeLikesDatabases
13 views

select ROUND(((CAST(SUM(CASE WHEN p.ID IS NULL THEN 1 ELS...

oct 13 MikeLikesDatabases
13 views

select (CAST(SUM(CASE WHEN p.ID IS NULL THEN 1 ELSE 0 END...

oct 13 MikeLikesDatabases
13 views

select count (1) from Users u

oct 13 MikeLikesDatabases
604 views

No of Users per location

oct 13 dejanualex
13 views

select count (1) from Users u where not exists (select 1 ...

oct 13 MikeLikesDatabases
604 views

No of Users per location

oct 13 dejanualex
12 views

select (CAST(SUM(CASE WHEN p.ID IS NULL THEN 1 ELSE 0 END...

oct 13 MikeLikesDatabases
11 views

select (SUM(CASE WHEN p.ID IS NULL THEN 1 ELSE 0 END)/COU...

oct 13 MikeLikesDatabases
604 views

No of Users per location

oct 13 dejanualex
14 views

select count(1) from Users;

oct 13 MikeLikesDatabases
13 views

select count(1) from Users;

oct 13 MikeLikesDatabases
14 views

select count (1) from Users u left join Posts p ON p.Owne...

oct 13 MikeLikesDatabases
14 views

select count (1) from Users u where not exists (select 1 ...

oct 13 MikeLikesDatabases
13 views

select count (1) from Users u where not exists (select 1 ...

oct 13 MikeLikesDatabases
13 views

select u.DisplayName, p.Title, p.CreationDate from Posts ...

oct 13 MikeLikesDatabases
14 views

select u.DisplayName, p.Title, p.CreationDate from Users ...

oct 13 MikeLikesDatabases
15 views

select u.DisplayName, p.Title, p.CreationDate from Users ...

oct 13 MikeLikesDatabases
15 views

select u.DisplayName, p.Title, p.CreationDate from Users ...

oct 13 MikeLikesDatabases
15 views

select u.DisplayName, p.Title, p.CreationDate from Users ...

oct 13 MikeLikesDatabases
15 views

select u.DisplayName, p.Title, p.CreationDate from Users ...

oct 13 MikeLikesDatabases
604 views

No of Users per location

oct 13 dejanualex
16 views

select u.DisplayName, p.Title, p.CreationDate from Users ...

oct 13 MikeLikesDatabases
22 views

Closed [r] questions

oct 13 margusl
1

554 views

Locations

oct 13 dejanualex
1

496 views

Number Of Users Form

oct 13 dejanualex
20 views

Closed [r] questions

oct 13 margusl
630 views

No of users in RO

oct 13 dejanualex
630 views

No of users in RO

oct 13 dejanualex
23 views

Closed [r] questions

oct 13
630 views

No of users in RO

oct 13 dejanualex
630 views

No of users in RO

oct 13 dejanualex
13 views

SELECT UPPER(location), count(1) over (partition by 1) as...

oct 13 MikeLikesDatabases
13 views

SELECT count(1) total_count FROM users WHERE (UPPER(locat...

oct 13 MikeLikesDatabases
14 views

SELECT UPPER(location), count(1) over (partition by 1) as...

oct 13 MikeLikesDatabases
12 views

SELECT UPPER(location), count(1) over (partition by 1) as...

oct 13 MikeLikesDatabases
13 views

SELECT UPPER(location), count(1) over (partition by 1) as...

oct 13 MikeLikesDatabases

30 50 100 per page