Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

WITH lv_users AS (SELECT Users.Id AS user_id, Badges....

dec 3
1 view

SELECT p.Id AS [ParentPostID], p.Id AS [PostID], CONCAT('...

dec 3
2 views

WITH lv_users AS (SELECT Users.Id AS user_id, Badges....

dec 3
4 views

WITH lv_users AS (SELECT Users.Id AS user_id, Badges....

dec 3
4 views

WITH lv_users AS (SELECT Users.Id AS user_id, Badges....

dec 3
2 views

SELECT TOP 1000 Posts.Body AS PostContent, Users.DisplayN...

dec 3 jon.doe46476
5 views

WITH lv_users AS (SELECT Users.Id AS user_id, Badges....

dec 3
9 views

WITH lv_users AS (SELECT Users.Id AS user_id, Badges....

dec 3
5 views

SELECT p.Body AS [Post Content], -- Содержание поста u.Di...

dec 3 jon.doe46476
10 views

WITH lv_users AS (SELECT Users.Id AS user_id, Badges....

dec 3
14 views

WITH lv_users AS (SELECT Users.Id AS user_id, Badges....

dec 3
120 views

SELECT p.Body AS [Post Content], -- Содержание поста u.Di...

dec 3 jon.doe46476
16 views

SELECT TOP 100 * FROM PostNotices WHERE CreationDa...

dec 3
120 views

SELECT p.Body AS [Post Content], -- Содержание поста u.Di...

dec 3 jon.doe46476
16 views

SELECT TOP 100 * FROM PostNotices

dec 3
18 views

WITH t1 AS (SELECT TOP 100 * FROM Posts ) SELECT t...

dec 3
120 views

SELECT p.Body AS [Post Content], -- Содержание поста u.Di...

dec 3 jon.doe46476
120 views

SELECT p.Body AS [Post Content], -- Содержание поста u.Di...

dec 3 jon.doe46476
120 views

SELECT (SELECT COUNT(*) FROM Posts) AS [Posts Count], -- ...

dec 3 jon.doe46476
21 views

WITH lv_users AS (SELECT Users.Id AS user_id, Badges....

dec 3
22 views

WITH lv_users AS (SELECT Users.Id AS user_id, Badges....

dec 3
120 views

SELECT p.Body AS [Post Content], -- Содержание поста (SEL...

dec 3 jon.doe46476
120 views

SELECT p.Body AS [Post Content], -- Содержание поста (SEL...

dec 3 jon.doe46476
22 views

WITH TagMaps AS (SELECT * FROM (VALUES ('sh','bash'), ('s...

dec 3
20 views

SELECT Users.Id, COUNT(Badges.Id) AS badge_count FROM ...

dec 3
24 views

SELECT Users.Id, COUNT(Badges.Id) AS badge_count FROM ...

dec 3
120 views

SELECT p.Body AS [Post Content], -- Содержание поста (SEL...

dec 3 jon.doe46476
25 views

SELECT TagName, [Count] FROM Tags WHERE TagName IN ('bash...

dec 3
120 views

SELECT p.Body AS [Post Content], -- Содержание поста (SEL...

dec 3 jon.doe46476
24 views

SELECT Location, COUNT(Id) loc_count FROM Users WHERE LO...

dec 3
25 views

SELECT Location, COUNT(Id) loc_count FROM Users WHERE LO...

dec 3
120 views

select DISTINCT OwnerUserId from Posts where PostTypeId= ...

dec 3 jon.doe46476
27 views

SELECT Location, COUNT(Id) loc_count FROM Users WHERE LO...

dec 3
120 views

select OwnerUserId -- вывод поль...

dec 3 jon.doe46476
26 views

SELECT Location, COUNT(Id) loc_count FROM Users WHERE LO...

dec 3
120 views

select OwnerUserId -- вывод поль...

dec 3 jon.doe46476
12 views

select OwnerUserId -- вывод поль...

dec 3 jon.doe46476
27 views

SELECT Location, COUNT(Id) loc_count FROM Users WHERE LO...

dec 3
27 views

SELECT Location, COUNT(Id) loc_count FROM Users GROUP BY...

dec 3
14 views

SELECT TagName, [Count] FROM Tags ORDER By [COUNT] DESC

dec 3
25 views

SELECT TagName, [Count] FROM Tags ORDER By [COUNT] DESC

dec 3
22 views

SELECT TagName, [Count] FROM Tags ORDER By [COUNT] DESC

dec 3
26 views

SELECT TOP 100 * FROM Users WHERE LOWER(Location) LIKE '%...

dec 3
25 views

SELECT TOP 100 * FROM Users WHERE LOWER(Location) LIKE '%...

dec 3
27 views

SELECT TOP 100 * FROM Users

dec 3
27 views

SELECT TOP 100 * FROM posts WHERE tags LIKE '%html%' AND ...

dec 3
15 views

SELECT TOP 100 * FROM Posts

dec 3
27 views

SELECT TOP 100 * FROM Posts

dec 3
27 views

SELECT TOP 100 * FROM Posts

dec 3
25 views

SELECT TOP 100 * FROM Posts

dec 3
26 views

SELECT TOP 100 * FROM Posts

dec 3
27 views

SELECT TOP 100 * FROM Posts

dec 3
27 views

SELECT TOP 100 * FROM Posts

dec 3
26 views

SELECT TOP 100 * FROM Posts

dec 3
27 views

SELECT TOP 100 * FROM Posts

dec 3
25 views

SELECT TOP 100 * FROM Posts

dec 3
24 views

SELECT TOP 100 * FROM Posts

dec 3
24 views

SELECT TOP 100 * FROM Posts

dec 3
20 views

SELECT TOP 100 * FROM Posts

dec 3
22 views

SELECT TOP 100 * FROM Posts

dec 3
21 views

SELECT TOP 100 * FROM Posts

dec 3
18 views

SELECT TOP 100 * FROM Posts

dec 3
16 views

SELECT TOP 100 * FROM Posts

dec 3
16 views

SELECT TOP 100 * FROM Posts

dec 3
14 views

SELECT TOP 100 * FROM Posts

dec 3
10 views

SELECT TOP 100 * FROM Posts

dec 3
9 views

SELECT TOP 100 * FROM Posts

dec 3
5 views

SELECT TOP 100 * FROM Posts

dec 3
4 views

SELECT TOP 100 * FROM Posts

dec 3
4 views

SELECT TOP 100 * FROM Posts

dec 3
2 views

SELECT TOP 100 * FROM Posts

dec 3
0 views

SELECT TOP 100 * FROM Posts

dec 3
17 views

select count(*) FROM POSTS;

dec 3
14 views

select count(*) from posts;

dec 3 jon.doe46475
74 views

select count(*) from posts

dec 3 jon.doe46475
74 views

select count(*) from posts

dec 3 jon.doe46475
74 views

select count(*) from posts

dec 3 jon.doe46475
74 views

select count(*) from users

dec 3 jon.doe46475
74 views

select count(*) from sys.tables

dec 3 jon.doe46475
28 views

NAADetector

dec 3
30 views

NAADetector

dec 3
16 views

SELECT TOP 10 * FROM Posts

dec 3
32 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
16 views

SELECT DISTINCT Users.DisplayName, Users.Location, Users....

dec 3
37 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
29 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
29 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
31 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
30 views

SELECT TOP 1000 u.Reputation, u.CreationDate, u.DisplayNa...

dec 3
31 views

SELECT TOP 1000 u.Reputation, u.CreationDate, u.DisplayNa...

dec 3
31 views

Select * from Users where Reputation = 20364

dec 3
16 views

Select Reputation from Users where Reputation = 20364

dec 3
31 views

Select Reputation from Users where Reputation = 20364

dec 3
31 views

Select Reputation from Users where Reputation = 20364

dec 3
30 views

Select Reputation from Users where Reputation = 20364

dec 3
60 views

Search all users that have the same badges as one particular user

dec 3 jon.doe46308
60 views

Search all users that have the same badges as one particular user

dec 3 jon.doe46308
60 views

Search all users that have the same badges as one particular user

dec 3 jon.doe46308
40 views

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

dec 3 Janis123
115 views

WITH Combos AS( SELECT pt.PostId, STRING_AGG(t.TagName,',...

dec 3 Janis123
115 views

WITH Combos AS( SELECT pt.PostId, STRING_AGG(t.TagName,',...

dec 3 Janis123
115 views

WITH Combos AS( SELECT pt.PostId, STRING_AGG(t.TagName,',...

dec 3 Janis123
115 views

WITH TopTags AS ( SELECT TOP 5 pt.TagId, COUNT(pt.PostId)...

dec 3 Janis123
28 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
27 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
40 views

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

dec 3 Janis123
31 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
32 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
14 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
32 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
31 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
27 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
28 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
31 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
29 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
29 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
37 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
32 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
115 views

WITH VotesMods AS ( SELECT PostId, SUM(CASE WHEN vt.Name ...

dec 3 Janis123
115 views

with x as ( select 'a' vc, 1 num union all select 'a' vc,...

dec 3 Janis123
115 views

with x as ( select 'a' vc, 1 num union all select 'a' vc,...

dec 3 Janis123
115 views

WITH VotesMods AS ( SELECT PostId, SUM(CASE WHEN vt.Name ...

dec 3 Janis123
40 views

select top(10) * from Posts pst where exists (select PostId

dec 3 Janis123
115 views

WITH PostsSelected AS( SELECT pt.PostId FROM PostTags pt ...

dec 3 Janis123
31 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
28 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
28 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
30 views

SELECT u.Id AS [User Link], CONCAT('https://serverfault.c...

dec 3
16 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
30 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
28 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
28 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
18 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
26 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
16 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
26 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
15 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
14 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
31 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
27 views

top users: Lithuania

dec 3
27 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
29 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
15 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
29 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
27 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3
28 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

dec 3

30 50 100 per page

2,276,893

queries

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Chinese language

12k questions

30k answers

53k comments

179 tags

nov 30 most recent