Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

763 views

SELECT Name, COUNT(1) FROM Badges GROUP BY Name order by ...

jul 30 10
831 views

SELECT Users.* FROM Users WHERE Users.DisplayName = 'Bog...

jul 30 10
793 views

SELECT DISTINCT(Name) FROM Badges

jul 30 10
751 views

SELECT Users.* FROM Users WHERE Users.Id = 23795

jul 30 10
760 views

SELECT Users.Id FROM Users WHERE Users.DisplayName = 'Bo...

jul 30 10
775 views

Select * from Posts WHeRE OwnerUserId = 181671

jul 30 10
781 views

SELECT * from Users Where ID = 181671

jul 30 10
835 views

SELECT TagName AS Tags, cnt AS [Questions Tagged], ROUN...

jul 30 10
801 views

SELECT TagName AS Tags, cnt AS [Questions Tagged], ROUN...

jul 30 10
785 views

SELECT TagName AS Tags, cnt AS [Questions Tagged], ROUN...

jul 30 10
763 views

Select top 100 * from Votes

jul 30 10 lord.quackstar
810 views

set nocount on declare @VoteStats table (PostId int, up ...

jul 30 10 lord.quackstar
799 views

set nocount on declare @VoteStats table (PostId int, up ...

jul 30 10 lord.quackstar
763 views

set nocount on declare @VoteStats table (PostId int, up ...

jul 30 10 lord.quackstar
5.7k views

Most downvoted questions and answers

jul 30 10 lord.quackstar
788 views

Select top 100 * from Posts where PostTypeId = 1

jul 30 10 lord.quackstar
802 views

Select top 100 * from Posts

jul 30 10 lord.quackstar
790 views

Select * from Votes

jul 30 10 lord.quackstar
781 views

set nocount on declare @VoteStats table (PostId int, up ...

jul 30 10 lord.quackstar
876 views

set nocount on declare @VoteStats table (PostId int, up ...

jul 30 10 lord.quackstar
822 views

set nocount on declare @VoteStats table (PostId int, up ...

jul 30 10 lord.quackstar
795 views

select top 100 * from posts

jul 30 10
753 views

Testing Query

jul 29 10
749 views

Testing Query

jul 29 10
799 views

select *, v.Id as [Post Link] from Votes v where v.VoteTy...

jul 29 10 Simon Brown
789 views

select * from Votes v where v.VoteTypeId = 9

jul 29 10 Simon Brown
813 views

select count(v.Id) from Votes v where v.VoteTypeId = 9 an...

jul 29 10 Simon Brown
799 views

select (select count(v.Id) from Votes v where v.VoteTypeI...

jul 29 10 Simon Brown
755 views

select count(v.Id) from Votes v where v.VoteTypeId = 8

jul 29 10 Simon Brown
742 views

Users with most downvotes

jul 29 10
764 views

Users with most downvotes

jul 29 10
763 views

select top 100 Id as [User Link], DownVotes, UpVotes, Do...

jul 29 10
773 views

select top 100 Id as [User Link], DownVotes, UpVotes, Do...

jul 29 10
739 views

select top 100 Id as [User Link], DownVotes from Users o...

jul 29 10
826 views

Top Users by Number of Bounties Won

jul 29 10 Alison
797 views

Users with the most comments

jul 29 10 jjnguy
749 views

Users with the most comments

jul 29 10 jjnguy
763 views

Users with the most comments

jul 29 10 jjnguy
754 views

Users with the most comments

jul 29 10 jjnguy
779 views

Users with the most comments

jul 29 10 jjnguy
751 views

Users with the most comments

jul 29 10 jjnguy
770 views

Users with the most comments

jul 29 10 jjnguy
741 views

Users with the most comments

jul 29 10 jjnguy
762 views

Users with the most comments

jul 29 10 jjnguy
790 views

Users with the most comments

jul 29 10 jjnguy
755 views

Users with the most comments

jul 29 10 jjnguy
818 views

Users with the most comments

jul 29 10 jjnguy
740 views

Users with the most comments

jul 29 10 jjnguy
761 views

Users with the most comments

jul 29 10 jjnguy
760 views

Users with the most comments

jul 29 10 jjnguy
763 views

Users with the most comments

jul 29 10 jjnguy
781 views

Users with the most comments

jul 29 10 jjnguy
770 views

Users with the most comments

jul 29 10 jjnguy
748 views

Users with the most comments

jul 29 10 jjnguy
757 views

Users with the most comments

jul 29 10 jjnguy
779 views

Users with the most comments

jul 29 10 jjnguy
729 views

Users with the most comments

jul 29 10 jjnguy
779 views

Users with the most comments

jul 29 10 jjnguy
776 views

Users with the most comments

jul 29 10 jjnguy
839 views

?????????????????????

jul 29 10 jjnguy
855 views

?????????????????????

jul 29 10 jjnguy
854 views

?????????????????????

jul 29 10 jjnguy
790 views

Top 100 Answers of All Time

jul 29 10
789 views

select * from votes where VoteTypeId = 5;

jul 29 10 johnmcauley
715 views

Downvoters - the people who downvote the most.

jul 29 10
756 views

Downvoters - the people who downvote the most.

jul 29 10
776 views

Downvoters - the people who downvote the most.

jul 29 10
687 views

Downvoters - the people who downvote the most.

jul 29 10
737 views

select * from votes where VoteTypeId = 5;

jul 29 10 johnmcauley
720 views

Downvoters - the people who downvote the most.

jul 29 10
755 views

Downvoters - the people who downvote the most.

jul 29 10
738 views

Downvoters - the people who downvote the most.

jul 29 10
759 views

Downvoters - the people who downvote the most.

jul 29 10
809 views

Downvoters - the people who downvote the most.

jul 29 10 mmyers
810 views

Downvoters - the people who downvote the most.

jul 29 10 mmyers
775 views

Downvoters - the people who downvote the most.

jul 29 10 mmyers
757 views

Downvoters - the people who downvote the most.

jul 29 10 mmyers
756 views

Downvoters - the people who downvote the most.

jul 29 10 mmyers
765 views

Downvoters - the people who downvote the most.

jul 29 10 mmyers
806 views

Downvoters - the people who downvote the most.

jul 29 10 mmyers
808 views

SELECT UserId from votes

jul 29 10
739 views

Downvoters - the people who downvote the most.

jul 29 10
748 views

SELECT * from votes

jul 29 10
783 views

select top 10 u1.DisplayName,'vs',u2.DisplayName from (se...

jul 29 10
762 views

select top 10 * from (select top 3 u.DisplayName, u.Id fr...

jul 29 10
764 views

select top 10 * from (select top 3 u.DisplayName from Use...

jul 29 10
763 views

select Top 30 * from (select v.PostId,v.UserId from Vote...

jul 29 10
786 views

select Top 10 * from (select v.PostId,v.UserId from Vote...

jul 29 10
731 views

select Top 10 * from (select v.PostId,v.UserId from Vote...

jul 29 10
755 views

select Top 10 * from (select Top 1000 v.PostId,v.UserId ...

jul 29 10
739 views

select Top 10 * from (select Top 100 v.PostId,v.UserId f...

jul 29 10
741 views

select Top 10 * from Votes v Inner join Users u on v.Use...

jul 29 10
726 views

select Top 10 * from Votes v Inner join Users u on v.Use...

jul 29 10
679 views

select Top 10 * from Votes v Inner join Users u on v.Use...

jul 29 10
778 views

select Top 10 * from Votes v Inner join Users u on v.Use...

jul 29 10
731 views

select Top 10 * from Votes v Inner join Users u on v.Use...

jul 29 10
780 views

select Top 10 * from Votes v join Users u on v.UserId=u....

jul 29 10
739 views

select Top 10 * from Votes v Inner join Users u on v.Use...

jul 29 10
759 views

select top 10 * from Votes where UserId is not null;

jul 29 10
731 views

select top 10 * from Votes where UserId IS not null;

jul 29 10

30 50 100 per page