Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

687 views

DECLARE @UserId int = ##UserId## select * from badges wh...

nov 9 10 abatishchev
648 views

DECLARE @UserId int = ##UserId## select p.Tags from Post...

nov 9 10 abatishchev
673 views

DECLARE @UserId int = ##UserId## select top 1 p.Tags fro...

nov 9 10 abatishchev
668 views

select top 1 p.Tags from Posts p WITH (NOLOCK) join Tags ...

nov 9 10 abatishchev
760 views

select top 1 t.Id from Tags t with (NOLOCK)

nov 9 10 abatishchev
690 views

select top 1 p.Tags from Posts p with (NOLOCK) select to...

nov 9 10 abatishchev
699 views

select top 1 p.Tags from Posts p with (NOLOCK)

nov 9 10 abatishchev
643 views

select top 100 Users.Id as [User ID], DisplayName, Reputa...

nov 9 10
685 views

select * from posts where id=871420;

nov 9 10
678 views

How many upvotes do I have towards tag-specialist badges?

nov 9 10
647 views

How many upvotes do I have towards tag-specialist badges?

nov 9 10
635 views

SELECT * FROM ( SELECT SUM(CASE V.VoteTypeId WHEN 1 THEN...

nov 8 10
644 views

SELECT SUM(CASE V.VoteTypeId WHEN 1 THEN 15 WHEN 2 THEN ...

nov 8 10
662 views

SELECT COUNT(*) AS cnt, V.CreationDate FROM Votes V JOIN...

nov 8 10
663 views

SELECT COUNT(*) AS cnt, V.CreationDate , SUM(1) FROM Vot...

nov 8 10
643 views

SELECT COUNT(*) AS cnt, V.CreationDate , 1 FROM Votes V ...

nov 8 10
631 views

SELECT COUNT(*) AS cnt, V.CreationDate , 1 FROM Votes V ...

nov 8 10
648 views

SELECT COUNT(*) AS cnt, V.CreationDate , 1 FROM Votes V ...

nov 8 10
627 views

SELECT COUNT(*) AS cnt, V.CreationDate FROM Votes V JOIN...

nov 8 10
690 views

SELECT COUNT(*), V.CreationDate FROM Votes V JOIN Posts ...

nov 8 10
640 views

SELECT COUNT(*), V.CreationDate FROM Votes V JOIN Posts ...

nov 8 10
681 views

SELECT COUNT(*), V.CreationDate FROM Votes V JOIN Posts ...

nov 8 10
700 views

SELECT COUNT(*), CreationDate FROM Votes WHERE UserId=90...

nov 8 10
669 views

select * from Votes where UserId is not null

nov 8 10
647 views

select * from Votes where BountyAmount is not null

nov 8 10
2

6.8k views

How many upvotes do I have towards tag-specialist badges?

nov 8 10 Roger Pate
1.8k views

How many upvotes do I have towards tag-specialist badges?

nov 8 10 Roger Pate
874 views

How many upvotes do I have towards tag-specialist badges?

nov 8 10 Roger Pate
731 views

Top Users by Number of Bounties Won

nov 8 10 dennis
746 views

Top Users by Number of Bounties Won

nov 8 10 dennis
699 views

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

nov 8 10
721 views

select top 100 Id as [Post ID], OwnerUserId, AcceptedAns...

nov 8 10
675 views

select top 100 Users.Id as [User ID], DisplayName, Reput...

nov 8 10
655 views

select top 2000 * from Posts order by 1

nov 8 10
698 views

Search a user's answers

nov 7 10
640 views

Search a user's answers

nov 7 10
5.4k views

Search a user's answers

nov 7 10 andreas.lundblad
780 views

SELECT Id, Score, Body, CreationDate FROM Posts WHERE ...

nov 7 10
658 views

select Id, Score, Body, CreationDate from Posts where Own...

nov 7 10
713 views

select Id, Score, Body, CreationDate from Posts where Own...

nov 7 10
713 views

select count(*) --PostId as [Post Link], Score, Text, Cre...

nov 7 10
696 views

SELECT count(*) FROM Posts WHERE OwnerUserId = 276052;

nov 7 10
694 views

SELECT Posts.id FROM Posts WHERE OwnerUserId = 276052;

nov 7 10
667 views

SELECT min(Posts.id) FROM Posts;

nov 7 10
669 views

SELECT max(Posts.id) FROM Posts;

nov 7 10
744 views

Testing

nov 7 10
688 views

select count(*) from Posts where (LastActivityDate > '20...

nov 7 10
612 views

select count(*) from Posts where (LastActivityDate < '20...

nov 7 10
667 views

select count(*) from Posts where (LastActivityDate < '20...

nov 7 10
717 views

select count(*) from Posts where (LastActivityDate < '20...

nov 7 10
680 views

select count(*) from Posts where (LastActivityDate < '20...

nov 7 10

30 50 100 per page