Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

84 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 4 Bowen.Zhou
180 views

select postid, count(1) from comments c where c.creationd...

dec 4 Janis123
84 views

select * from comments

dec 4 Bowen.Zhou
84 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 4 Bowen.Zhou
84 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 4 Bowen.Zhou
84 views

select * from comments

dec 4 Bowen.Zhou
180 views

WITH aggregated_votes AS ( SELECT PostId, COUNT(CASE WHEN...

dec 4 Janis123
84 views

WITH TempTable AS ( SELECT OwnerUserId, COUNT(CASE WHEN C...

dec 4 Bowen.Zhou
24 views

select id,name from closereasontypes

dec 4
180 views

WITH aggregated_votes AS ( SELECT PostId, COUNT(CASE WHEN...

dec 4 Janis123
180 views

WITH aggregated_votes AS ( SELECT PostId, COUNT(CASE WHEN...

dec 4 Janis123
180 views

select top 5 p.Id, p.tags from posts p inner join ( selec...

dec 4 Janis123
180 views

select p.Id, count(1) from posts p inner join ( select Po...

dec 4 Janis123
180 views

select p.Id, p.tags from posts p inner join ( select PostId

dec 4 Janis123
23 views

select id,name from votetypes

dec 4
23 views

select id,name from posttypes

dec 4
11 views

select id,name from posthistorytypes

dec 4
23 views

select id,name from posthistorytypes

dec 4
23 views

select id,name from posthistorytypes

dec 4
24 views

select id,name from posthistorytypes

dec 4
12 views

SELECT YEAR(CreationDate) AS year, t.TagName AS tag, COUN...

dec 4 jon.doe46483
12 views

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

dec 4
12 views

SELECT YEAR(CreationDate) AS Year, TagName, COUNT(*) AS Q...

dec 4
13 views

with AnswerScores AS ( SELECT Users.Id AS [User Link], SU...

dec 4
1

29 views

Search text in comments by User ID

dec 4 Ivan.Shatsky
30 views

Search text in comments by User ID (ServerFault)

dec 4 Ivan.Shatsky
11 views

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

dec 4
21 views

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

dec 4
21 views

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

dec 4
131 views

SELECT TOP 10 Users.DisplayName AS UserName -- Имя пользо...

dec 4 jon.doe46476
131 views

SELECT TOP 10 Users.DisplayName AS UserName -- Имя пользо...

dec 4 jon.doe46476
24 views

select table_name as [Table(Links to Sample Data)], --sam...

dec 4
24 views

select table_name as [Table(Links to Sample Data)], --sam...

dec 4
25 views

select table_name as [Table(Links to Sample Data)], --sam...

dec 4
25 views

select table_name as [Table(Links to Sample Data)], --sam...

dec 4
13 views

select 'query://874190/?table='+table_name+'|'+table_name...

dec 4
25 views

select 'query://874190/?table='+table_name+'|'+table_name...

dec 4
25 views

select 'query://874190/?table='+table_name+'|'+table_name...

dec 4
24 views

select 'query://874190/?table='+table_name+'|'+table_name...

dec 4
24 views

select 'query://874190/?table='+table_name+'|'+table_name...

dec 4
16 views

select 'query://874190/?table='+table_name+'|'+table_name...

dec 4
28 views

Unsung Posts

dec 4
26 views

Lowest voted posts

dec 4
27 views

Unsung Posts

dec 4
131 views

SELECT TOP 10 Users.DisplayName AS UserName -- Имя пользо...

dec 4 jon.doe46476
131 views

SELECT TOP 10 Posts.Id AS PostId, -- Уникальн...

dec 4 jon.doe46476
131 views

SELECT TOP 10 Users.Id AS UserId, -- Уникал...

dec 4 jon.doe46476
131 views

SELECT TOP 10 Users.DisplayName AS UserName, -- Имя по...

dec 4 jon.doe46476
131 views

SELECT TOP 10 Users.DisplayName AS UserName, -- Имя по...

dec 4 jon.doe46476
131 views

SELECT TOP 10 Users.DisplayName AS UserName, -- Имя по...

dec 4 jon.doe46476
131 views

SELECT TOP 10 Users.DisplayName AS UserName, Posts.Body A...

dec 4 jon.doe46476
131 views

SELECT Users.DisplayName AS UserName, -- Имя пользоват...

dec 4 jon.doe46476
13 views

SELECT FORMAT(18000.32, '###,###,###,###.##')

dec 4
13 views

select top 20 * from posts

dec 4
27 views

Highcharts

dec 4
28 views

Highcharts

dec 4
27 views

Highcharts

dec 4
30 views

Highcharts

dec 4

30 50 100 per page

2,277,279

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