Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

14 views

select p.id, p.title,p.viewcount from posts p join postta...

oct 21
12 views

select count(*) from users left outer join comments c on ...

oct 21
12 views

select top 100 * from posts join users on users.id = post...

oct 21
11 views

select * from posts join users on users.id = posts.id

oct 21
13 views

select p.id, p.title,p.viewcount from posts p join postta...

oct 21
13 views

select count(*) from posts join users on users.id = posts...

oct 21
12 views

select count(id) from users where id in(select UserId fro...

oct 21
13 views

select count(*) from posts join users on users.id = posts...

oct 21
13 views

select count(*) from posts join users on users.id = posts...

oct 21
16 views

select * from posts where id in ( select pt.postid from p...

oct 21
13 views

select count(id) from users where id in(select UserId fro...

oct 21
13 views

/*select count(*) from users join comments c on users.id ...

oct 21
13 views

select count(id) from users where id in(select OwnerUserI...

oct 21
11 views

select count(*) from users join comments c on users.id = ...

oct 21
11 views

select count(*) from users join comments c on users.id = ...

oct 21
11 views

select count(*) from users join comments c on users.id = ...

oct 21
12 views

/*select count(*) from users join posts p on users.id = p...

oct 21
11 views

select count(id) from users where id in(select OwnerUserI...

oct 21
11 views

/*select count(*) from users join posts p on users.id = p...

oct 21
12 views

select count(*) from users join posts p on users.id = p.id

oct 21
11 views

select count(*) from users join posts p on users.id = p.i...

oct 21
11 views

select count(*) from users join posts p on users.id = p.i...

oct 21
12 views

select count(id) from users where id in(select OwnerUserI...

oct 21
26 views

Select

oct 21
24 views

Posts

oct 21
11 views

select count(*) from users left outer join posts p on use...

oct 21
9 views

select id from users where id in(select OwnerUserId from ...

oct 21
25 views

Posts

oct 21
20 views

SELECT Distinct TagName FROM Users u, Posts p, PostTags p...

oct 21 jon.doe34657
11 views

select id from users where id not in(select OwnerUserId f...

oct 21
24 views

Tags que utilizó alguna vez Jon Skeet

oct 21
13 views

SELECT DISTINCT TagName FROM Users u, Posts p, PostTags p...

oct 21
11 views

SELECT TagName FROM Users u, Posts p, PostTags pt, Tags t...

oct 21
12 views

SELECT t.TagName FROM Users u, Posts p, PostTags pt, Tags t

oct 21
12 views

select TOP 10 * from Users where DisplayName LIKE 'marc...

oct 21
11 views

select id from users where not exists(select OwnerUserId ...

oct 21
11 views

select TOP 10 * from Users where DisplayName LIKE '%ano%'

oct 21
11 views

select TOP 10 * from Users where DisplayName LIKE 'Mari...

oct 21
12 views

select distinct t.tagname from tags as t, posttags as pt,...

oct 21
11 views

select id from users where not exists(select OwnerUserId,...

oct 21
11 views

select count(OwnerUserId) from Posts group by OwnerUserId...

oct 21
10 views

select OwnerUserId, count(id) from Posts group by OwnerUs...

oct 21
11 views

select DISTINCT (Name) from Badges where TagBased = 0;

oct 21
11 views

SELECT DISTINCT Name FROM Badges WHERE TagBased = 0;

oct 21
20 views

select Distinct Name from Badges WHERE TagBased = 0

oct 21 jon.doe34657
12 views

SELECT DISTINCT Name FROM Badges WHERE TagBased=0;

oct 21
25 views

Nombres de badges que no dependen de tags

oct 21
12 views

select Name from Badges where TagBased = 0;

oct 21
20 views

select top 50 * from Badges WHERE TagBased = 0

oct 21 jon.doe34657
10 views

SELECT DISTINCT Name FROM Badges WHERE TagBased = 0;

oct 21
12 views

select TOP 10 * from Badges where TagBased = 0;

oct 21
12 views

SELECT DISTINCT Name FROM Badges WHERE TagBased = 0;

oct 21
10 views

SELECT DISTINCT(Name) FROM Badges WHERE TagBased = 0;

oct 21
10 views

select count(distinct id) from Users where Id not in (sel...

oct 21
11 views

SELECT DISTINCT(Name) FROM Badges WHERE TagBased = 'false';

oct 21
9 views

select TOP 10 * from Badges;

oct 21
12 views

select TOP 10 * from Badges;

oct 21
12 views

select TOP 10 * from Badges;

oct 21
11 views

select TOP 10 * from Badges;

oct 21
11 views

select TOP 10 * from Badges;

oct 21
11 views

select TOP 10 * from Badges;

oct 21
12 views

select TOP 10 * from Badges;

oct 21
10 views

SELECT DISTINCT Class, Name FROM Badges;

oct 21
10 views

select distinct name from badges where tagbased='false';

oct 21
7 views

select distinct name from badges where tagbased='true';

oct 21
10 views

select distinct name from badges where tagbased='true';

oct 21
12 views

select distinct name from badges where tagbased='true';

oct 21
16 views

select distinct name from badges where tagbased='true';

oct 21
13 views

select distinct name from badges where tagbased='true';

oct 21
14 views

select distinct name from badges where tagbased='true';

oct 21
16 views

select distinct name from badges where tagbased='true';

oct 21
8 views

SELECT COUNT(*) FROM Badges;

oct 21
11 views

SELECT COUNT(*) FROM Badges;

oct 21
10 views

SELECT COUNT(*) FROM Badges;

oct 21
9 views

SELECT DISTINCT Class FROM Badges;

oct 21
10 views

SELECT DISTINCT Class FROM Badges;

oct 21
12 views

SELECT DISTINCT Class FROM Badges;

oct 21
12 views

SELECT DISTINCT Class FROM Badges;

oct 21
10 views

SELECT DISTINCT Name FROM Badges

oct 21
9 views

SELECT top 10 * FROM Badges

oct 21
25 views

Nombres de badges que no dependen de tags

oct 21
10 views

SELECT top 10 * FROM Badges

oct 21
8 views

with countmonth as (select distinct eomonth(creationdate)...

oct 21
20 views

select top 3 * from Badges

oct 21 jon.doe34657
20 views

select count(*) from Badges

oct 21 jon.doe34657
10 views

select * from Badges

oct 21
9 views

with countmonth as (select distinct eomonth(creationdate)...

oct 21
9 views

SELECT COUNT(*) FROM Users WHERE DisplayName LIKE '%Gasto...

oct 21
10 views

SELECT COUNT(*) FROM Users WHERE DisplayName LIKE '%Ramir...

oct 21
7 views

SELECT TOP 10 * FROM Users WHERE DisplayName LIKE 'Ramiro...

oct 21
20 views

select count(*) from Users WHERE DisplayName LIKE 'Nico%'

oct 21 jon.doe34657
7 views

with countmonth as (select distinct eomonth(creationdate)...

oct 21
8 views

select count(distinct id) from Users where exists (select...

oct 21
9 views

SELECT COUNT(*) FROM Users WHERE DisplayName LIKE 'Ramiro...

oct 21
8 views

SELECT COUNT(*) FROM Users WHERE displayName LIKE 'Marian...

oct 21
8 views

SELECT TOP 10 * FROM Users WHERE displayName LIKE 'Marian...

oct 21
10 views

with countmonth as (select distinct eomonth(creationdate)...

oct 21
10 views

select count(distinct id) from Users where exists (select...

oct 21
9 views

select count(distinct id) from Users where Id in (select ...

oct 21
11 views

SELECT (SELECT COUNT(*) FROM Posts) - (SELECT COUNT(*) FR...

oct 21
9 views

SELECT 2+3;

oct 21
10 views

SELECT (SELECT COUNT(*) FROM Posts) - (SELECT COUNT(*) FR...

oct 21
10 views

with cmonth as (select distinct eomonth(creationdate) as m,

oct 21
10 views

SELECT COUNT(*) - COUNT(ParentId) FROM Posts

oct 21
10 views

SELECT COUNT(*) - COUNT(ParentId) FROM Posts

oct 21
9 views

SELECT COUNT(*) FROM Posts;

oct 21
20 views

select count(*) from Users

oct 21 jon.doe34657
9 views

select count(distinct id) from Users where Id in (select ...

oct 21
8 views

select count(distinct id) from Users where Id in (select ...

oct 21
9 views

SELECT COUNT(*) FROM Posts WHERE ParentId IS NULL

oct 21
9 views

SELECT COUNT(*) FROM Posts WHERE ParentId IS NULL;

oct 21
8 views

SELECT COUNT(*) FROM Posts WHERE ParentId IS NOT NULL;

oct 21
9 views

select distinct eomonth(creationdate),count(id) over(part...

oct 21
7 views

select eomonth(creationdate),count(id) over(partition by ...

oct 21
8 views

select month(creationdate),count(id) over(partition by mo...

oct 21
8 views

select count(distinct id) from Users where Id not in (sel...

oct 21
7 views

select month(creationdate),count(*) over(partition by mon...

oct 21
9 views

SELECT COUNT(*) FROM Posts WHERE ParentId IS NULL

oct 21

30 50 100 per page

1,594,492

queries

Q&A about the site for scholars and enthusiasts of literature

393 questions

790 answers

3.2k comments

88 tags

oct 18 most recent