Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

210 views

Select q.Id as [Post Link] from Posts q INNER JOIN Posts ...

sep 9 PeterJames
210 views

Select q.Id as [Post Link] from Posts q INNER JOIN Posts ...

sep 9 PeterJames
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
210 views

Select top 500 q.Id as [Post Link], sum(a.score) from Pos...

sep 9 PeterJames
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
210 views

Select top 500 q.Id as [Post Link], q.id, q.score, a.id, ...

sep 9 PeterJames
210 views

Select top 100 q.Id as [Post Link], q.id, q.score, a.id, ...

sep 9 PeterJames
210 views

Select top 100 q.Id as [Post Link], q.id, q.score, a.id, ...

sep 9 PeterJames
210 views

Select top 20 q.Id as [Post Link], q.id, q.score, a.id, a...

sep 9 PeterJames
210 views

Select top 20 q.Id as [Post Link], q.id, q.score, a.id, a...

sep 9 PeterJames
210 views

Select top 10 q.Id as [Post Link], q.id, q.score, a.id, a...

sep 9 PeterJames
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
210 views

Select top 10 q.Id as [Post Link], q.id, q.score, a.id, a...

sep 9 PeterJames
210 views

Select top 10 q.Id as [Post Link], q.id, q.score, a.id, a...

sep 9 PeterJames
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
210 views

Select top 10 q.Id as [Post Link], q.id, a.id, * from Pos...

sep 9 PeterJames
210 views

Select top 10 q.Id as [Post Link], * from Posts q INNER J...

sep 9 PeterJames
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
169 views

WITH TempTable AS ( SELECT OwnerUserId FROM posts WHERE P...

sep 9 Bowen.Zhou
210 views

Select top 10 ParentId as [Post Link], * from Posts where...

sep 9 PeterJames
210 views

Select top 10 *, ParentId as [Post Link] from Posts where...

sep 9 PeterJames
210 views

Select top 10 * from Posts where PostTypeId = 2 and Creat...

sep 9 PeterJames
210 views

Select top 10 * from Posts where PostTypeId = 3 and Creat...

sep 9 PeterJames
210 views

Select top 10 * from Posts where PostTypeId = 3 and Creat...

sep 9 PeterJames
27 views

OpenClassRooms Exercise

sep 9
171 views

select case WHEN cnt_post.cnt_post = 0 THEN '0' WHEN cnt_...

sep 9 jon.doe45636
171 views

select case WHEN cnt_post.cnt_post = 0 THEN '0' WHEN cnt_...

sep 9 jon.doe45636
171 views

select case WHEN p.cnt_post = 0 THEN '0' WHEN p.cnt_post ...

sep 9 jon.doe45636
171 views

select count(*) as more_than_10 from users u where exist...

sep 9 jon.doe45636
171 views

select id from posts p group by p.id having count(*) > 1

sep 9 jon.doe45636
171 views

select id from posts p group by p.id having count(*) > 2

sep 9 jon.doe45636
171 views

select id from posts p group by p.id having count(*) > 9

sep 9 jon.doe45636
171 views

select id from posts p group by p.id having count(*) > 10

sep 9 jon.doe45636
171 views

select count(*) as more_than_10 from users u where exist...

sep 9 jon.doe45636
171 views

select round(comment.null_comment * 100 / total.total_use...

sep 9 jon.doe45636
171 views

select round(comment.null_comment * 100 / total.total_use...

sep 9 jon.doe45636
171 views

select (comment.null_comment * 100 / total.total_user) * ...

sep 9 jon.doe45636
171 views

select (comment.null_comment / total.total_user) * 100,co...

sep 9 jon.doe45636
171 views

select (comment.null_comment / total.total_user) * 100 from

sep 9 jon.doe45636
171 views

select * from (select count(*) as komentare_null from use...

sep 9 jon.doe45636
171 views

select count(*) from users u where not exists(select * fr...

sep 9 jon.doe45636
171 views

select u.DisplayName, p.creationdate from users u join po...

sep 9 jon.doe45636
171 views

select DisplayName from users u join posts p on u.id = p....

sep 9 jon.doe45636

30 50 100 per page

2,249,150

queries

Q&A for professional robotic engineers, hobbyists, researchers and students

47k questions

54k answers

28k comments

1.3k tags

sep 7 most recent