Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

842 views

select top 100 p.* from votes v join posts p on v.postid ...

jul 27 10 jrista
785 views

select top 100 p.* from votes v join posts p on v.postid ...

jul 27 10 jrista
782 views

select top 100 p.* from votes v join posts p on v.postid ...

jul 27 10 jrista
864 views

select top 100 p.* from votes v join posts p on v.postid ...

jul 27 10 jrista
802 views

select top 100 p.* from votes v join posts p on v.postid ...

jul 27 10 jrista
756 views

/* Id = 13494 */ /* select Title from Posts where OwnerU...

jul 27 10
819 views

/* Id = 13494 */ /* select Title from Posts where OwnerU...

jul 27 10
821 views

/* Id = 13494 */ select Title from Posts where OwnerUser...

jul 27 10
806 views

select DisplayName from Users where Id = 13494

jul 27 10
783 views

select Id, DisplayName, Location from Users where Users.R...

jul 27 10
817 views

select Id, DisplayName from Users where Users.Reputation ...

jul 27 10
774 views

select Id from Users where Users.Reputation = 41 and User...

jul 27 10
833 views

select Title from Posts, Users where Users.Reputation = 4...

jul 27 10
774 views

select Posts.Title from Posts where Posts.OwnerUserId = 2...

jul 27 10
833 views

select Posts.Title from Posts, Users where Posts.OwnerUse...

jul 27 10
823 views

select Posts.Title from Posts, Users where Posts.OwnerUse...

jul 27 10
800 views

select Posts.Title from Posts, Users where Users.Id = 2718

jul 27 10
808 views

select Posts.Title from Posts, Users where Users.id = 2718

jul 27 10
832 views

/* select Posts.Title, Posts.Id from Posts, Users where P...

jul 27 10
795 views

/* select Posts.Title, Posts.Id from Posts, Users where P...

jul 27 10
768 views

/* select Posts.Title, Posts.Id from Posts, Users where P...

jul 27 10
812 views

/* select Posts.Title, Posts.Id from Posts, Users where P...

jul 27 10
779 views

/* select Posts.Title, Posts.Id from Posts, Users where P...

jul 27 10
774 views

/* select Posts.Title, Posts.Id from Posts, Users where P...

jul 27 10
763 views

/* select Posts.Title, Posts.Id from Posts, Users where P...

jul 27 10
744 views

/* select Posts.Title, Posts.Id from Posts, Users where P...

jul 27 10
727 views

/* select Posts.Title, Posts.Id from Posts, Users where P...

jul 27 10
760 views

/* select Posts.Title, Posts.Id from Posts, Users where P...

jul 27 10
742 views

/* select Posts.Title, Posts.Id from Posts, Users where P...

jul 27 10
844 views

select Posts.Title, Posts.Id from Posts, Users where Post...

jul 27 10
755 views

select top 10 Posts.Title, Posts.Id from Posts, Users whe...

jul 27 10
819 views

select top 10 Posts.Title, Posts.Id from Posts

jul 27 10
836 views

/* select top 10 Title, Posts.Id from Posts, Users where ...

jul 27 10
789 views

/* select top 10 Title, Posts.Id from Posts, Users where ...

jul 27 10
816 views

/* select top 10 Title, Posts.Id from Posts, Users where ...

jul 27 10
794 views

/* select top 10 Title, Posts.Id from Posts, Users where ...

jul 27 10
780 views

/* select top 10 Title, Posts.Id from Posts, Users where ...

jul 27 10
800 views

select top 10 Title, Posts.Id from Posts, Users where Pos...

jul 27 10
823 views

select top 10 Title from Posts, Users where Posts.OwnerUs...

jul 27 10
777 views

select top 10 Title from Posts where OwnerUserId = 1

jul 27 10
870 views

select top 10 body from Posts

jul 27 10
925 views

select body from Posts

jul 27 10
831 views

select 'body' from Posts

jul 27 10
991 views

Get user's rank and percentile for a specified tag

jul 27 10
835 views

Select * from sys.database_permissions p

jul 27 10
1k views

Get user's rank and percentile for a specified tag

jul 27 10
1k views

Get user's rank and percentile for a specified tag

jul 27 10
952 views

Get user's rank and percentile for a specified tag

jul 27 10
973 views

Get user's rank and percentile for a specified tag

jul 27 10
871 views

Get user's rank and percentile for a specified tag

jul 27 10
834 views

Get user's rank and percentile for a specified tag

jul 27 10
848 views

select count(*) from users where location IN ('India','US...

jul 27 10
794 views

select count(*) from users where location IN ('India','US...

jul 27 10
849 views

DECLARE @UserId int = ##UserId##, @TagName varchar(255) ...

jul 27 10
820 views

select count(*) from users where location='India'

jul 27 10
799 views

select count(*) from users where location='ahmedabad'

jul 27 10
769 views

select * from users where websiteurl like '%nowebsite%' o...

jul 27 10
840 views

select * from users where websiteurl like '%nowebsite%'

jul 27 10
863 views

select * from users where displayname like '%pratik%'

jul 27 10
4.7k views

Common post scores

jul 27 10 Simon Brown
878 views

create table #PostScores ( Score int ) insert into #Post...

jul 27 10 Simon Brown
897 views

create table #PostScores ( Score int ) insert into #Post...

jul 27 10 Simon Brown
856 views

DECLARE @UserId int = ##UserId##, @TagName varchar(255) ...

jul 27 10
835 views

DECLARE @UserId int = ##UserId##, @TagName varchar(255) ...

jul 27 10
771 views

DECLARE @UserId int = ##UserId##, @TagName varchar(255) ...

jul 27 10
793 views

DECLARE @UserId int = ##UserId##, @TagName varchar(255) ...

jul 27 10
820 views

DECLARE @UserId int = ##UserId##, @TagName varchar(255) ...

jul 27 10
822 views

DECLARE @UserId int = ##UserId##, @TagName varchar(255) ...

jul 27 10
828 views

select * from users where displayname like '%Nagrani%'

jul 27 10
831 views

select * from users where displayname like '%Romil%'

jul 27 10
807 views

DECLARE @UserId int = ##UserId##, @TagName varchar(255) ...

jul 27 10
885 views

DECLARE @UserId int = ##UserId##, @TagName varchar(255) ...

jul 27 10
861 views

SELECT TOP 1 USER FROM Posts

jul 27 10
808 views

SELECT * FROM Users WHERE REputation > 10000 ORDER BY Rep...

jul 27 10
782 views

SELECT * FROM Users WHERE REputation > 10000

jul 27 10
815 views

SELECT DISTINCT PostTypeId from Posts

jul 27 10
915 views

Most popular StackOverflow tags in May 2010

jul 27 10
863 views

SELECT * FROM Votes WHERE UserId = 213474 SELECT * FROM...

jul 27 10
803 views

SELECT * FROM Votes WHERE UserId = 213474

jul 27 10
768 views

SELECT * FROM Votes WHERE UserId = 213474 AND VoteTypeId...

jul 27 10
808 views

SELECT * FROM Votes WHERE UserId = 213474 AND VoteTypeId...

jul 27 10
792 views

SET NOCOUNT ON DECLARE @UserId INT SELECT @UserId = 213...

jul 27 10
783 views

DECLARE @UserId INT SELECT @UserId = 213474 DECLARE @To...

jul 27 10
847 views

DECLARE @UserId INT SELECT @UserId = 213474 DECLARE @To...

jul 27 10
807 views

DECLARE @UserId INT SELECT @UserId = 213474 DECLARE @To...

jul 27 10
776 views

DECLARE @UserId INT SELECT @UserId = 213474 DECLARE @To...

jul 27 10
786 views

DECLARE @UserId INT SELECT @UserId = 213474 DECLARE @To...

jul 27 10
796 views

DECLARE @UserId INT SELECT @UserId = 213474 DECLARE @To...

jul 27 10
828 views

DECLARE @UserId INT SELECT @UserId = 213474 DECLARE @To...

jul 27 10
791 views

DECLARE @TotalCount BIGINT SELECT @TotalCount = COUNT(*)...

jul 27 10
854 views

DECLARE @TotalCount BIGINT SELECT @TotalCount = COUNT(*)...

jul 27 10
824 views

DECLARE @TotalCount BIGINT SELECT @TotalCount = COUNT(*)...

jul 27 10
775 views

SELECT TOP 1000 Reputation, DisplayName FROM Users WHERE...

jul 27 10
790 views

SELECT TOP 1000 Reputation, DisplayName FROM Users WHERE...

jul 27 10
846 views

SELECT TOP 1000 Reputation, DisplayName FROM Users ORDER...

jul 27 10
838 views

SELECT TOP 100 Reputation, DisplayName FROM Users ORDER ...

jul 27 10
861 views

SELECT Reputation, DisplayName FROM Users

jul 27 10
838 views

SELECT * FROM Users WHERE Age <= 23 AND Reputation > 1000

jul 27 10
847 views

SELECT * FROM Users WHERE Age <= 23

jul 27 10
787 views

SELECT * FROM Posts

jul 27 10

30 50 100 per page

2,285,169

queries

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Chinese language

12k questions

30k answers

53k comments

178 tags

jan 11 most recent