Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

4 views

SELECT format(CreationDate,'yyyy - MM') AS Time, PostType...

jan 17
4 views

SELECT format(CreationDate,'yyyy - MM') AS Time, PostType...

jan 17
4 views

select FORMAT(CreationDate,'MMM yyyy'),count(distinct Id)...

jan 17
5 views

SELECT name, count(*) AS 'cnt' FROM badges GROUP BY name;

jan 17
5 views

SELECT ID, DisplayName, Location FROM Users

jan 17
5 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
6 views

SELECT ID, DisplayName, Location FROM Users

jan 17
7 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
7 views

SELECT Name, count(*) AS 'Number of User' FROM Badges GRO...

jan 17
7 views

SELECT Name, count(*) AS 'Number of User' FROM Badges GRO...

jan 17
7 views

SELECT Name, count(*)FROM Badges GROUP BY name HAVING cou...

jan 17
10 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
10 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
9 views

SELECT Name, count(*)FROM Badges GROUP BY name;

jan 17
9 views

SELECT Name FROM Badges GROUP BY name;

jan 17
9 views

SELECT * FROM badges;

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
9 views

select * from Users

jan 17
8 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
8 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
8 views

select distinct Users.DisplayName, Users.Location, Use...

jan 17
9 views

SELECT * FROM Badges;

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users

jan 17
8 views

SELECT format(CreationDate,'yyyy - MM') AS 'Newdate' ,cou...

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
9 views

SELECT format(CreationDate,'yyyy - MM') AS 'Newdate' ,cou...

jan 17
8 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
11 views

SELECT ID, DisplayName, Location FROM Users WHERE Locatio...

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users

jan 17
8 views

SELECT ID, DisplayName, Location FROM Users

jan 17
14 views

SELECT ID, DisplayName, Location FROM Users

jan 17
11 views

SELECT ID, DisplayName, Location FROM Users

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users

jan 17
8 views

SELECT ID, DisplayName, Location FROM Users

jan 17
8 views

SELECT ID, DisplayName, Location FROM Users

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users

jan 17
9 views

SELECT ID, DisplayName, Location FROM Users

jan 17
10 views

SELECT ID, DisplayName, Location FROM Users

jan 17
10 views

SELECT ID, DisplayName, Location FROM Users

jan 17
7 views

SELECT ID, DisplayName, Location FROM Users

jan 17
6 views

SELECT ID, DisplayName, Location FROM Users

jan 17
5 views

SELECT ID, DisplayName, Location FROM Users

jan 17
5 views

SELECT ID, DisplayName, Location FROM Users

jan 17
11 views

SELECT format(CreationDate,'yyyy - MM') AS Time, PostType...

jan 17
20 views

Post tagged 'nodejs'

jan 17
21 views

Post tagged 'nodejs'

jan 17
21 views

Post tagged 'nodejs'

jan 17
11 views

SELECT format(CreationDate,'yyyy - MM') AS 'NewDate' ,cou...

jan 17
13 views

SELECT format(CreationDate,'yyyy - MM') AS 'NewDate' ,cou...

jan 17
11 views

SELECT format(CreationDate,'yyyy - MM') AS 'NewDate' ,cou...

jan 17
8 views

SELECT format(CreationDate,'yyyy - MM') AS 'NewDate' ,cou...

jan 17
9 views

SELECT format(CreationDate,'yyyy - MM') AS 'NewDate' ,cou...

jan 17
9 views

SELECT format(CreationDate,'yyyy - MM') AS 'NewDate' ,cou...

jan 17
5 views

SELECT format(CreationDate,'yyyy - MM') AS 'NewDate' ,cou...

jan 17
13 views

SELECT format(CreationDate,'yyyy - MM') AS Time, PostType...

jan 17
11 views

SELECT format(CreationDate,'yyyy - MM') AS Time ,count(*)...

jan 17
13 views

select FORMAT(CreationDate,'MMM yyyy'),count(distinct Id)...

jan 17
11 views

SELECT format(CreationDate,'yyyy - MM') AS Time ,count(*)...

jan 17
11 views

SELECT format(CreationDate,'yyyy - MM') AS Time ,count(*)...

jan 17
12 views

SELECT format(CreationDate,'yyyy - MM') AS Time ,count(*)...

jan 17
14 views

select * from Tags WHERE id in ( select TagId from PostTa...

jan 17
15 views

select TagId from PostTags where PostId = 59701609

jan 17
13 views

SELECT format(CreationDate,'yyyy - MM') ,count(*) FROM po...

jan 17
13 views

SELECT * from Posts

jan 17
14 views

select * from Tags WHERE id in ( select id from PostTags ...

jan 17
14 views

select * from Tags WHERE id in ( select id from PostTags ...

jan 17
12 views

SELECT format(CreationDate,'MM-yyyy') ,count(*) FROM post...

jan 17
12 views

SELECT format(CreationDate,'MM-yy') ,count(*) FROM posts ...

jan 17
15 views

select top 10 * from Posts where posttypeid = 1 and id =...

jan 17
12 views

SELECT format(CreationDate,'MM-yy') AS Date ,count(*) FRO...

jan 17
14 views

select top 10 * from PostTags where PostId = 59701609

jan 17
16 views

Number of users that answer 10 or more questions a month

jan 17
13 views

select top 10 * from Posts where posttypeid = 1 order by...

jan 17
14 views

select * from PostTypes

jan 17
15 views

select top 10 * from Posts order by id desc

jan 17
13 views

select * from Posts where id = 59702904

jan 17
14 views

select top 10 * from PostTags order by PostId desc

jan 17
12 views

select count(distinct Id) as "Number of posts", min(Creat...

jan 17
13 views

select count(distinct Id) as "Number of posts", min(Creat...

jan 17
4 views

select count(distinct Id) as "Number of posts", min(Creat...

jan 17
15 views

select * from Posts where id = 59702904

jan 17
14 views

select top 10 * from PostTags order by PostId desc selec...

jan 17
14 views

select top 10 * from PostTags order by PostId desc

jan 17
11 views

select distinct Users.DisplayName, Users.Location, Use...

jan 17
14 views

select top 10 * from Posts order by id desc

jan 17
14 views

select top 10 * from Posts order by id desc

jan 17
15 views

select top 10 * from Posts order by id desc

jan 17
14 views

select top 10 * from Posts order by id desc

jan 17
13 views

select top 10 * from Posts order by id desc

jan 17
15 views

select top 10 * from Posts order by id desc

jan 17
14 views

select top 10 * from Posts order by id desc

jan 17
13 views

select top 10 * from Posts order by id desc

jan 17
14 views

select top 10 * from Posts order by id desc

jan 17
15 views

select top 10 * from Posts order by id desc

jan 17
14 views

select top 10 * from Posts order by id desc

jan 17
14 views

select top 10 * from Posts order by id desc

jan 17
15 views

select top 10 * from Posts order by id desc

jan 17
15 views

select top 10 * from Posts order by id desc

jan 17
14 views

select top 10 * from Posts order by id desc

jan 17
8 views

select distinct Users.DisplayName, Users.Location, Use...

jan 17
11 views

select distinct Users.DisplayName, Users.Location, Use...

jan 17
11 views

select distinct Users.DisplayName, Users.Location, Use...

jan 17
12 views

SELECT format(CreationDate,'%Y-%m') AS Date ,count(*) FRO...

jan 17
11 views

SELECT COUNT(DISTINCT Id) AS number_of_post, MIN(Creation...

jan 17
23 views

Manage Big Data Assignment1

jan 17
12 views

SELECT COUNT(DISTINCT Id) AS number_of_post, MIN(Creation...

jan 17
11 views

select distinct Posts.Id, Posts.Title, Posts.Score, Posts...

jan 17
11 views

select distinct Posts.Id, Posts.Title, Posts.Score, Posts...

jan 17
11 views

select distinct Posts.Id, Posts.Title, Posts.Score, Posts...

jan 17
21 views

Post tagged 'nodejs'

jan 17
22 views

Post tagged 'nodejs'

jan 17
18 views

Answered/Unanswered Questions by Month since 2016

jan 17
18 views

Answered/Unanswered Questions by Month since 2016

jan 17
12 views

SELECT FORMAT(CreationDate,'yyyy-MM') AS 'year-month', CO...

jan 17
16 views

select * from Posts;

jan 17
14 views

SELECT YEAR(CreationDate) [Year], MONTH(CreationDate) [Mo...

jan 17
14 views

SELECT YEAR(CreationDate) [Year], MONTH(CreationDate) [Mo...

jan 17
13 views

SELECT YEAR(CreationDate) [Year], MONTH(CreationDate) [Mo...

jan 17
13 views

SELECT YEAR(CreationDate), MONTH(CreationDate)FROM posts

jan 17
14 views

SELECT YEAR(CreationDate) [Year], MONTH(CreationDate) [Mo...

jan 17
11 views

CREATE table #yourtable ([Id] int, [Value] varchar(6), [C...

jan 17
17 views

SELECT YEAR(CreationDate) [Year], MONTH(CreationDate) [Mo...

jan 17
16 views

SELECT CreationDate, count(*) FROM posts GROUP BY Creatio...

jan 17
13 views

select * from Users where Id=1139196

jan 17
26 views

Manage Big Data Assignment1

jan 17
16 views

select top 1000000 Id, AccountId, Reputation, Upvotes fro...

jan 17
16 views

SELECT CreationDate FROM posts;

jan 17
14 views

SELECT creationDate FROM posts;

jan 17
13 views

WITH Raw AS ( SELECT DATEFROMPARTS( DATEPART(yyyy, Creati...

jan 17 peterh - PLEASE DELETE THIS ACCOUNT
14 views

select top 1000000 Id, AccountId, UpVotes from Users orde...

jan 17
28 views

Manage Big Data Assignment1

jan 17
16 views

select top 1000000 Id, UpVotes from Users order by -UpVot...

jan 17

30 50 100 per page

1,433,343

queries

Q&A for Muslims, experts in Islam, and those interested in learning more about Islam

11k questions

17k answers

35k comments

543 tags

jan 12 most recent