Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

16 views

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

oct 13 MikeLikesDatabases
14 views

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

oct 13 MikeLikesDatabases
15 views

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

oct 13 MikeLikesDatabases
15 views

SELECT UPPER(location) FROM users WHERE UPPER(location) L...

oct 13 MikeLikesDatabases
14 views

SELECT UPPER(location) FROM users WHERE UPPER(location) I...

oct 13 MikeLikesDatabases
14 views

SELECT UPPER(location) FROM users WHERE UPPER(location) I...

oct 13 MikeLikesDatabases
14 views

SELECT UPPER(location) FROM users WHERE UPPER(location) I...

oct 13 MikeLikesDatabases
14 views

SELECT location FROM users WHERE UPPER(location) IN ('CZE...

oct 13 MikeLikesDatabases
15 views

SELECT count(1) as cnt FROM users WHERE UPPER(location) I...

oct 13 MikeLikesDatabases
17 views

SELECT count(1) FROM users WHERE UPPER(location) IN ('CZE...

oct 13 MikeLikesDatabases
15 views

SELECT * FROM users WHERE (WebsiteUrl IS NULL OR WebsiteU...

oct 13 MikeLikesDatabases
13 views

SELECT * FROM users WHERE WebsiteUrl IS NULL OR WebsiteUr...

oct 13 MikeLikesDatabases
13 views

select u.* from Users u where (WebsiteUrl is null OR Webs...

oct 13
12 views

select u.* from Users u where (WebsiteUrl is null OR Webs...

oct 13
7 views

select users.id from Users

oct 13
12 views

select users.id from Users

oct 13
13 views

select users.id from Users

oct 13
13 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
17 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
14 views

select users.id from Users

oct 13
14 views

select users.id from Users

oct 13
14 views

select users.id from Users

oct 13
14 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
14 views

select users.id from Users

oct 13
16 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
18 views

select users.id from Users

oct 13
17 views

select users.id from Users

oct 13
16 views

select users.id from Users

oct 13
17 views

select users.id from Users

oct 13
17 views

select users.id from Users

oct 13
16 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
16 views

select users.id from Users

oct 13
16 views

select users.id from Users

oct 13
16 views

select users.id from Users

oct 13
16 views

select users.id from Users

oct 13
13 views

select users.id from Users

oct 13
14 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
15 views

select users.id from Users

oct 13
14 views

select users.id from Users

oct 13
13 views

select users.id from Users

oct 13
13 views

select users.id from Users

oct 13
11 views

select users.id from Users

oct 13
13 views

select users.id from Users

oct 13
12 views

select users.id from Users

oct 13
12 views

select users.id from Users

oct 13
13 views

select users.id from Users

oct 13
12 views

select users.id from Users

oct 13
13 views

select users.id from Users

oct 13
12 views

select users.id from Users

oct 13
12 views

select users.id from Users

oct 13
12 views

select users.id from Users

oct 13
11 views

select users.id from Users

oct 13
13 views

select users.id from Users

oct 13
12 views

select users.id from Users

oct 13
12 views

select users.id from Users

oct 13
12 views

select users.id from Users

oct 13
12 views

select users.id from Users

oct 13
13 views

select users.id from Users

oct 13
20 views

Top 110 from Pune

oct 13
11 views

SELECT p.Id, p.AcceptedAnswerId, p.CreationDate, p.Score,...

oct 13
14 views

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

oct 13
15 views

SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUserId

oct 13
16 views

/*SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUs...

oct 13
15 views

/*SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUs...

oct 13
12 views

/*SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUs...

oct 13
14 views

/*SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUs...

oct 13
15 views

/*SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUs...

oct 13
96 views

Question 4

oct 13 Akarsh.Jain
12 views

SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUserId

oct 13
9 views

select count(Id) from Posts where CommentCount IS NULL

oct 13 Akarsh.Jain
15 views

SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUserId

oct 13
14 views

SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUserId

oct 13
15 views

SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUserId

oct 13
16 views

SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUserId

oct 13
7 views

SELECT (COUNT(CASE WHEN CommentCount = 0 or CommentCount ...

oct 13 Akarsh.Jain
14 views

/*SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUs...

oct 13
12 views

/*SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUs...

oct 13
13 views

/*SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUs...

oct 13
12 views

SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUserId

oct 13
12 views

SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUserId

oct 13
14 views

SELECT p.Id, p.Title, p.Body, p.CreationDate, p.OwnerUserId

oct 13
11 views

SELECT Id, Title, Body, CreationDate, OwnerUserId FROM Po...

oct 13
7 views

WITH PostCounts AS ( SELECT OwnerUserId AS UserId, COUNT(...

oct 13 Akarsh.Jain
13 views

SELECT OwnerUserId, COUNT(*) AS QuestionCount FROM Posts ...

oct 13 jon.doe46009
15 views

select top 10 * from posts

oct 13
13 views

SELECT OwnerUserId FROM posts WHERE (CreationDate BETWEEN...

oct 13 jon.doe46009
7 views

SELECT P.OwnerUserId, COALESCE(P.OwnerDisplayName, U.Disp...

oct 13 Akarsh.Jain
33 views

Question 3

oct 13 Akarsh.Jain
33 views

Question 3

oct 13 Akarsh.Jain
89 views

SELECT TOP 10 u.Id AS UserId, u.DisplayName, COUNT(DISTIN...

oct 13 Akarsh.Jain
9 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
15 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
11 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
14 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
12 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
12 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
13 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
12 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
14 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
16 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
15 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
14 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
15 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
12 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
15 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
14 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
12 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
15 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
16 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
15 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
14 views

Select u.id as userid, count(*) from users u join posts p...

oct 13
89 views

SELECT TOP 10 u.Id AS UserId, u.DisplayName, COUNT(DISTIN...

oct 13 Akarsh.Jain
89 views

SELECT TOP 10 u.Id AS UserId, u.DisplayName, COUNT(DISTIN...

oct 13 Akarsh.Jain
89 views

SELECT TOP 100 u.Id AS UserId, u.DisplayName, COUNT(DISTI...

oct 13 Akarsh.Jain
89 views

SELECT TOP 10 u.Id AS UserId, u.DisplayName, COUNT(DISTIN...

oct 13 Akarsh.Jain
89 views

SELECT TOP 10 u.Id AS UserId, u.DisplayName, COUNT(DISTIN...

oct 13 Akarsh.Jain
89 views

SELECT TOP 100 u.Id AS UserId, u.DisplayName, COUNT(DISTI...

oct 13 Akarsh.Jain
89 views

SELECT TOP 100 u.Id AS UserId, u.DisplayName, COUNT(DISTI...

oct 13 Akarsh.Jain
89 views

SELECT TOP 100 u.Id AS UserId, u.DisplayName, COUNT(DISTI...

oct 13 Akarsh.Jain
89 views

SELECT u.Id AS UserId, u.DisplayName, COUNT(DISTINCT c.Po...

oct 13 Akarsh.Jain
267 views

select top 500 Concat('https://stackoverflow.com/question...

oct 13 nalka
21 views

SELECT p.Id, p.AcceptedAnswerId, p.CreationDate, p.Score,...

oct 13
21 views

SELECT p.Id, p.AcceptedAnswerId, p.CreationDate, p.Score,...

oct 13
19 views

SELECT p.Id, p.AcceptedAnswerId, p.CreationDate, p.Score,...

oct 13
10 views

SELECT p.Id, p.AcceptedAnswerId, p.CreationDate, p.Score,...

oct 13
19 views

SELECT p.Id, p.AcceptedAnswerId, p.CreationDate, p.Score,...

oct 13
21 views

SELECT p.Id, p.AcceptedAnswerId, p.CreationDate, p.Score,...

oct 13
21 views

SELECT p.Id, p.AcceptedAnswerId, p.CreationDate, p.Score,...

oct 13
11 views

SELECT p.Id, p.AcceptedAnswerId, p.CreationDate, p.Score,...

oct 13
11 views

SELECT COUNT(*) FROM Users WHERE Location LIKE '%Czech%' OR

oct 13
49 views

Question 5

oct 13 Akarsh.Jain
49 views

Question 5

oct 13 Akarsh.Jain
49 views

Question 5

oct 13 Akarsh.Jain
9 views

SELECT u.Id, u.DisplayName, u.Reputation, COUNT(DISTINCT ...

oct 13 Akarsh.Jain
68 views

Question 5

oct 13 Akarsh.Jain
10 views

with question_answer as( select t.tagname, q.id as q...

oct 13
10 views

with question_answer as( select t.tagname, q.id as qid, a...

oct 13
68 views

Question 5

oct 13 Akarsh.Jain
10 views

with question_answer as( select t.tagname, q.id as qid, a...

oct 13
96 views

Question 4

oct 13 Akarsh.Jain
10 views

with question_answer as( select t.tagname, q.id as ques, ...

oct 13
44 views

Question 2

oct 13 Akarsh.Jain
37 views

Question 1

oct 13 Akarsh.Jain
44 views

Question 2

oct 13 Akarsh.Jain
68 views

Question 5

oct 13 Akarsh.Jain
68 views

Question 5

oct 13 Akarsh.Jain
68 views

SELECT STRING_AGG(t.TagId, ', ') AS Tags, COUNT(t.TagId) ...

oct 13 Akarsh.Jain
68 views

SELECT TOP 100 STRING_AGG(t.TagId, ', ') AS Tags, COUNT(t...

oct 13 Akarsh.Jain
68 views

SELECT TOP 10 STRING_AGG(t.TagId, ', ') AS Tags, COUNT(t....

oct 13 Akarsh.Jain
12 views

with question_answer as( select t.tagname, q.id as qu...

oct 13
12 views

with question_answer as( select t.tagname, q.id as qu...

oct 13
12 views

with question_answer as( select t.tagname, q.id as qu...

oct 13
12 views

with question_answer as( select t.tagname, q.id as qu...

oct 13
68 views

CREATE TABLE #PostCounts (UserId INT, PostCount INT);

oct 13 Akarsh.Jain
68 views

SELECT Id, CommentCount FROM Posts ORDER BY CommentCount ...

oct 13 Akarsh.Jain
68 views

SELECT Id, CommentCount FROM Posts ORDER BY CreationDate ...

oct 13 Akarsh.Jain
96 views

Question 4

oct 13 Akarsh.Jain
24 views

Select sum(posts.score), users.id from users LEFT JOIN po...

oct 13
24 views

Select * from users LEFT JOIN posts on users.id = posts.o...

oct 13
96 views

Question 4

oct 13 Akarsh.Jain
96 views

Question 4

oct 13 Akarsh.Jain
12 views

Select * from users where reputation > 1000

oct 13
24 views

Select * from users where reputation > 1000

oct 13
24 views

Select * from users where reputation > 1000

oct 13
28 views

SELECT u.Id, u.DisplayName, u.Reputation, COUNT(DISTINCT ...

oct 13 Akarsh.Jain
28 views

SELECT u.Id, u.DisplayName, u.Reputation, COUNT(DISTINCT ...

oct 13 Akarsh.Jain
12 views

WITH PostCounts AS ( SELECT P.OwnerUserId AS UserId, COUN...

oct 13 Akarsh.Jain
18 views

SELECT P.OwnerUserId, COALESCE(P.OwnerDisplayName, U.Disp...

oct 13
37 views

Question 1

oct 13
22 views

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

oct 13

30 50 100 per page