Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

526 views

SELECT OwnerUserID FROM Posts

nov 19 10
566 views

select distinct name from badges

nov 19 10
635 views

select * from badges order by name

nov 19 10
563 views

select * from badges

nov 19 10
653 views

SELECT * FROM Users WHERE DisplayName = 'Lei'

nov 19 10 lord.quackstar
643 views

select userid as [User Link] from badges where name = 'M...

nov 18 10 chris65536
678 views

select year(date) as Yr, month(date) as Mnth, count(*) as N

nov 18 10 chris65536
651 views

select year(date) as Yr, month(date) as Mnth, count(*) as N

nov 18 10 chris65536
651 views

select userid as [User Link] from badges where name = 'M...

nov 18 10 chris65536
703 views

select max(date) from badges where name = 'Mortarboard'

nov 18 10 chris65536
662 views

select * from badges

nov 18 10 chris65536
598 views

select count (*) from posts

nov 18 10
500 views

select count (*) from posts where answercount=0

nov 18 10
548 views

SELECT p.Id AS [Post Link], p.AnswerCount FROM Posts a, P...

nov 18 10 Chris
593 views

SELECT p.Id AS [Post Link], p.AnswerCount FROM Posts a, P...

nov 18 10 Chris
549 views

SELECT p.Id AS [Post Link], p.AnswerCount FROM Posts a, P...

nov 18 10 Chris
623 views

SELECT p.Id AS [Post Link], a.AnswerCount FROM Posts a, P...

nov 18 10 Chris
589 views

select top 20 * from comments where text like '%tomblin%'...

nov 18 10
599 views

select * from comments where text like '%tomblin%'

nov 18 10
578 views

select top 30 u.id, u.displayname, u.reputation, count(*)...

nov 18 10
560 views

select u.id, u.displayname, u.reputation, count(*) edits ...

nov 18 10
567 views

select u.id, u.displayname, u.reputation, count(*) edits ...

nov 18 10
577 views

select u.id, u.displayname, u.reputation, count(*) edits ...

nov 18 10
653 views

select body from posts where id = 3592454

nov 18 10 chris65536
563 views

select top 20 * from posthistory

nov 18 10
582 views

select u.id, u.displayname, u.reputation, count(*) edits ...

nov 18 10
562 views

select u.id, u.displayname, u.reputation, count(*) edits ...

nov 18 10
583 views

select u.id, u.displayname, u.reputation, count(*) edits ...

nov 18 10
556 views

select u.id, u.displayname, u.reputation, count(*) edits ...

nov 18 10
564 views

select u.id, u.displayname, u.reputation, count(*) edits ...

nov 18 10
580 views

select u.id, u.displayname, u.reputation, count(*) from u...

nov 18 10
630 views

select count(*) from Posts p inner join posthistory ph on...

nov 18 10
589 views

DECLARE @UserId int = ##UserId## SELECT * FROM Comments ...

nov 18 10
633 views

DECLARE @UserId int = ##UserId## SELECT PostID FROM Comm...

nov 18 10
608 views

DECLARE @UserId int = ##UserId## SELECT Top 10 * FROM Co...

nov 18 10
678 views

All time insightful comments

nov 18 10 sam.saffron
683 views

select p.tags from Posts p left join posts pl on (pl.tags...

nov 18 10 z
661 views

select count(p.ID) from Posts p left join posts pl on (pl...

nov 18 10 z
662 views

select (select count(pr.Id) from Posts pr where pr.tags ...

nov 18 10 z
664 views

select (select count(pr.Id) from Posts pr where pr.tags ...

nov 18 10 z
615 views

select (select count(pr.Id) from Posts pr where pr.tags ...

nov 18 10 z
654 views

select (select count(pr.Id) from Posts pr where pr.tags ...

nov 18 10 z
651 views

select (select count(pr.ID) from Posts pr where pr.tags ...

nov 18 10 z
673 views

select (select count(*) from Posts pr where pr.tags like...

nov 18 10 z
647 views

select tags,count(*) from Posts where tags IN (select t...

nov 18 10 z
684 views

select Posts.Id, tags from Posts where tags like '%<##Ta...

nov 18 10 z
618 views

select Posts. Id, tags from Posts where tags like '%<##T...

nov 18 10 z
651 views

select * from users where id= 229044

nov 18 10
654 views

SELECT SUM(ans.Score) AS TotalScore, ans.OwnerUserId FRO...

nov 18 10
640 views

SELECT * FROM Posts WHERE Id IN (1258296, 1575610)

nov 18 10

30 50 100 per page

2,263,177

queries

Q&A about the site for alcoholic beverage aficionados and those interested in beer, wine, or spirits

98 questions

142 answers

367 comments

75 tags

mar 7 most recent