Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

8 views

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

oct 13 Akarsh.Jain
8 views

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

oct 13 Akarsh.Jain
14 views

SELECT (COUNT(CASE WHEN CommentCount = 0 THEN 1 END) * 10...

oct 13 Akarsh.Jain
8 views

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

oct 13
7 views

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

oct 13
14 views

SELECT (COUNT(CASE WHEN CommentCount = 0 THEN 1 END) * 10...

oct 13 Akarsh.Jain
14 views

SELECT (COUNT(CASE WHEN CommentCount = 0 THEN 1 END) * 10...

oct 13 Akarsh.Jain
4 views

Select * from users where reputation > 1000

oct 13
7 views

Select * from users where reputation > 1000

oct 13
8 views

Select * from users where reputation > 1000

oct 13
15 views

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

oct 13 Akarsh.Jain
15 views

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

oct 13 Akarsh.Jain
7 views

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

oct 13 Akarsh.Jain
11 views

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

oct 13
19 views

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

oct 13
22 views

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

oct 13
21 views

WITH RecentPosts AS ( SELECT p.OwnerUserId, p.Title, p.Vi...

oct 13
22 views

WITH TotalUsers AS ( SELECT COUNT(*) AS total_users FROM ...

oct 13
53 views

select body from posts p where p.id = 37893633512024

oct 13 TroubleDOG0100
53 views

select body from posts p where p.id = 37893633512024

oct 13 TroubleDOG0100
22 views

WITH TotalUsers AS ( SELECT COUNT(*) AS total_users FROM ...

oct 13
53 views

declare @month datetime = '##Year##-##Month##-01' declare...

oct 13 TroubleDOG0100
53 views

select score from posts p where p.score > 1000

oct 13 TroubleDOG0100
53 views

select score from posts p where p.score > 1000

oct 13 TroubleDOG0100
22 views

WITH TotalUsers AS ( SELECT COUNT(*) AS total_users FROM ...

oct 13
122 views

SELECT Count(*) FROM Posts;

oct 13 Sudhanshu.Soni
122 views

SELECT Count(Id) FROM Users;

oct 13 Sudhanshu.Soni
122 views

SELECT Count(AccountId) FROM Users;

oct 13 Sudhanshu.Soni
122 views

SELECT Count(Id) FROM Users;

oct 13 Sudhanshu.Soni
122 views

SELECT Count(*) FROM Users;

oct 13 Sudhanshu.Soni
122 views

SELECT Count(Id) FROM Users;

oct 13 Sudhanshu.Soni
22 views

SELECT COUNT(*) FROM ( SELECT OwnerUserId FROM Posts GROU...

oct 13
122 views

SELECT Count(Id) FROM Users;

oct 13 Sudhanshu.Soni
122 views

SELECT Count(Id) FROM Users;

oct 13 Sudhanshu.Soni
122 views

SELECT Count(Id) FROM Users;

oct 13 Sudhanshu.Soni
122 views

SELECT Id FROM Users;

oct 13 Sudhanshu.Soni
122 views

SELECT COUNT(*) FROM Users;

oct 13 Sudhanshu.Soni
22 views

SELECT COUNT(*) FROM ( SELECT OwnerUserId FROM Posts GROU...

oct 13
22 views

SELECT COUNT(*) FROM ( SELECT OwnerUserId FROM Posts GROU...

oct 13
22 views

SELECT COUNT(*) FROM ( SELECT OwnerUserId FROM Posts GROU...

oct 13
122 views

SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABL...

oct 13 Sudhanshu.Soni
21 views

SELECT ROUND(100.0 * COUNT(us.Id) / (SELECT COUNT(*) FROM...

oct 13
22 views

SELECT ROUND(100.0 * COUNT(us.Id) / (SELECT COUNT(*) FROM...

oct 13
21 views

SELECT COUNT(*) FROM Users AS us LEFT JOIN Posts AS po O...

oct 13
22 views

SELECT COUNT(*) FROM Users AS us LEFT JOIN Posts AS po O...

oct 13
22 views

SELECT COUNT(*) FROM Users AS us LEFT JOIN Posts AS po O...

oct 13
22 views

SELECT us.DisplayName, po.Title FROM Users AS us INNER J...

oct 13
22 views

SELECT us.DisplayName, po.Title FROM Users AS us INNER J...

oct 13
22 views

SELECT us.DisplayName, po.Title FROM Users AS us INNER J...

oct 13
22 views

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

oct 13
11 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
21 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
21 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
21 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
22 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
19 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13
20 views

SELECT * FROM Users WHERE WebsiteUrl IS NULL;

oct 13

30 50 100 per page

2,263,502

queries

Q&A about the site for active researchers, academics and students of physics

3.5k questions

6k answers

32k comments

117 tags

oct 12 most recent