Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

4 views

select groups, cast(count_in_group as float)/cast(total_u...

dec 9
5 views

select groups, count_in_group/total_user_count as percent...

dec 9
6 views

select * from comments where PostId IN (select p1.Id a...

dec 9
7 views

select groups, total_user_count, count(Id) from ( select ...

dec 9
8 views

select groups, total_user_count, count(Id) from ( select ...

dec 9
8 views

select groups, total_user_count, count(Id) from ( select ...

dec 9
8 views

select groups, total_user_count from ( select Id, case wh...

dec 9
8 views

select groups, total_user_count from ( select Id, case wh...

dec 9
9 views

select groups, total_user_count from ( select Id, case wh...

dec 9
9 views

select *,groups, total_user_count from ( select *, case w...

dec 9
8 views

select *,groups, total_user_count from ( select *, case w...

dec 9
8 views

select *,groups, total_user_count from ( select *, case w...

dec 9
8 views

select groups, total_user_count from ( select *, case whe...

dec 9
8 views

select *, groups, total_user_count from ( select *, case ...

dec 9
8 views

select *, groups, total_user_count from ( select *, case ...

dec 9
8 views

select groups, total_user_count from ( select *, case whe...

dec 9
8 views

select groups, [user_count_in_group] = count(Id) over(par...

dec 9
8 views

select groups, [user_count_in_group] = count(Id) over(par...

dec 9
8 views

select groups, [user_count_in_group] = count(Id) over(par...

dec 9
8 views

select groups, count(groups), [user_count_in_group] = cou...

dec 9
8 views

select groups, count(groups) from ( select *, case when "...

dec 9
8 views

select groups, [user_count_in_group] = count(Id) over(par...

dec 9
8 views

select groups, total_user_count, [user_count_in_group] = ...

dec 9
8 views

select *, [user_count_in_group] = count(Id) over(partitio...

dec 9
9 views

select *, [user_count_in_group] = count(Id) over(partitio...

dec 9
9 views

select *, [percentages] = count(Id) over(partition by gro...

dec 9
9 views

select *, [percentages] = count(groups) over(partition by...

dec 9
9 views

select * from ( select *, case when "post_count" = 0 then...

dec 9
9 views

select *, case when "post_count" = 0 then '0' when "post_...

dec 9
10 views

select groups from (select *, case when "post_count" = 0...

dec 9
10 views

select *, case when "post_count" = 0 then '0' when "post...

dec 9
9 views

select *, case when "post_count" = 0 then '0' when "post...

dec 9
9 views

select *, case when "post_count" = 0 then '0' when "post...

dec 9
9 views

select *, case when "post_count" = 0 then '0' when "post...

dec 9
18 views

Number of questions/answers/posts per Year

dec 9 jon.doe43058
18 views

Number of questions/answers/posts per Year

dec 9 jon.doe43058
18 views

Number of questions/answers/posts per Year

dec 9 jon.doe43058
9 views

select count(Id) from (select u.Id, count(p.Id) as "post...

dec 9
9 views

select u.Id, count(p.Id) from Users u full outer join Pos...

dec 9
9 views

select round(1 - (cast(t1."with_post" as float)/cast(t2."...

dec 9
9 views

select *, round(1 - (cast(t1."with_post" as float)/cast(t...

dec 9
9 views

select *, (cast(t1."with_post" as float)/cast(t2."all" as...

dec 9
9 views

select *, 100-(cast(t1."with_post" as float)/cast(t2."all...

dec 9
9 views

select *, round(100-(cast(t1."with_post" as float)/cast(t...

dec 9
9 views

select *, round(100-(cast(t1."with_post" as float)/cast(t...

dec 9
9 views

select *, round(cast(t1."with_post" as float)/cast(t2."al...

dec 9
9 views

select *, round(100 - cast(t1."with_post" as float)/cast(...

dec 9
10 views

select *, cast(t1."with_post" as float)/cast(t2."all" as ...

dec 9
10 views

select *, cast(t1."with_post"/t2."all" as float) as "res"...

dec 9
10 views

select *, t1."with_post"/t2."all" as "res" from (select ...

dec 9
10 views

select *, t2."all"+t1."with_post" as "res" from (select ...

dec 9
10 views

select *, t2."all"/t1."with_post" as "res" from (select ...

dec 9
11 views

select * from (select count(distinct u.Id) as "with_post...

dec 9
12 views

SELECT Id AS [Post Link], (SELECT MAX(v) FROM (VALUES (Cl...

dec 9
11 views

select t1.with_post/t2."all" as "res" from (select count...

dec 9
11 views

select t2."all"/t1.with_post as "res" from (select count...

dec 9
10 views

select * from (select count(distinct u.Id) as "with_post...

dec 9
10 views

select * from (select count(distinct u.Id) as "with_post...

dec 9
9 views

select * from comments where PostId IN (select p2.Id a...

dec 9
9 views

select * from comments where PostId IN (select p1.Id a...

dec 8
8 views

select "group", count(Id) from (select u.Id, 'with_post'...

dec 8
8 views

select u.Id, 'with_post' as "group" from Users u full out...

dec 8
9 views

select count(distinct u.DisplayName) from Users u full ou...

dec 8
9 views

SELECT * FROM Posts WHERE ( UPPER(Tags) LIKE UPPER('%secu...

dec 8
9 views

select count(u.DisplayName) from Users u full outer join ...

dec 8
9 views

SELECT * FROM Posts WHERE ( UPPER(Tags) LIKE UPPER('%secu...

dec 8
9 views

SELECT * FROM Posts WHERE ( UPPER(Tags) LIKE UPPER('%secu...

dec 8
10 views

select * from comments where PostId IN (select p1.Id a...

dec 8
9 views

select u.DisplayName from Users u full outer join Posts p...

dec 8
10 views

select count(distinct u.DisplayName) from Users u full ou...

dec 8
10 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
10 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
10 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
10 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
11 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
11 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
11 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
10 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
10 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
10 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
10 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
10 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
10 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
10 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
9 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
8 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
7 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
5 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
4 views

select top 10 u.DisplayName from Users u full outer join ...

dec 8
10 views

SELECT * FROM Posts WHERE ( UPPER(Tags) LIKE UPPER('%secu...

dec 8
9 views

SELECT * FROM Posts WHERE ( UPPER(Tags) LIKE UPPER('%secu...

dec 8
9 views

SELECT * FROM Posts WHERE ( UPPER(Tags) LIKE UPPER('%secu...

dec 8
9 views

SELECT * FROM Posts WHERE ( UPPER(Tags) LIKE UPPER('%secu...

dec 8
10 views

SELECT * FROM Posts WHERE ( UPPER(Tags) LIKE UPPER('%secu...

dec 8
9 views

select top 10 u.DisplayName, p.Title from Users u join Po...

dec 8
8 views

select p1.Id as QId, p1.PostTypeId as QPostTypeId, p1.Ac...

dec 8
8 views

select p1.Id as QId, p1.PostTypeId as QPostTypeId, p1.Ac...

dec 8
8 views

select p1.Id as QId, p1.PostTypeId as QPostTypeId, p1.Ac...

dec 8
8 views

select * from Users where Location like '[Cc]zech%' or Lo...

dec 8
10 views

select * from Users where Location like '[Cc]zech%' or Lo...

dec 8
11 views

select * from Users where Location in ('Czech', 'czech', ...

dec 8
12 views

select * from Users where Location in ('Czech', 'czech', ...

dec 8
11 views

select * from Users where WebsiteUrl is null;

dec 8
12 views

select * from Users where WebsiteUrl is null;

dec 8
11 views

select * from Users where WebsiteUrl is null;

dec 8
10 views

select * from Users where WebsiteUrl is null;

dec 8
8 views

select * from Users where WebsiteUrl is null;

dec 8
9 views

select * from Users where WebsiteUrl is null;

dec 8
10 views

SELECT top 5 TagName, CNT, AvgAns FROM ( SELECT TagName, ...

dec 8
10 views

SELECT top 5 TagName, CNT, AvgAns FROM ( SELECT TagName, ...

dec 8
9 views

With PopularTag as ( Select top 5 TagName, WikiPostId, Ex...

dec 8
8 views

Select top 3 * from Tags order by Count desc

dec 8
8 views

Select top 3 * from Tags

dec 8
9 views

With TopPost as ( Select Title, Tags, FavoriteCount, DENS...

dec 8
9 views

With TopPost as ( Select Title, Tags, FavoriteCount, ROW_...

dec 8
27 views

select ROW_NUMBER() OVER (ORDER BY tuser.Tag_Score desc) AS User_Rank_On_Tag, (PERCENT_RANK(

dec 8
8 views

With TopUsers AS ( Select Top 3 DisplayName, Id From User...

dec 8
8 views

WITH TopUsers AS ( Select Top 3 DisplayName, Id From User...

dec 8
8 views

SELECT TOP 3 Users.DisplayName, Posts.Title, Posts.ViewCo...

dec 8
9 views

SELECT * FROM RelatedQuestions WHERE RelatedPostId=77539033

dec 8 dan1st
9 views

SELECT * FROM RelatedQuestions WHERE PostId=77539033

dec 8 dan1st
9 views

SELECT * FROM PostLinks WHERE PostId=77539033

dec 8 dan1st
9 views

SELECT * FROM PostLinks WHERE RelatedPostId=77539033

dec 8 dan1st
10 views

Select top 20 DisplayName, Views From Users Order by View...

dec 8
10 views

DECLARE @InputYear INT = ##Year:int## SELECT PostTypeId...

dec 8
10 views

DECLARE @InputYear INT SELECT PostTypeId, COUNT(DISTINC...

dec 8

30 50 100 per page

2,175,329

queries

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

138 questions

242 answers

446 comments

77 tags

may 3 most recent