Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

766 views

WITH c AS ( SELECT LEN(TagName) AS TagLength, COUNT(Id) ...

aug 3 10
727 views

WITH c AS ( SELECT LEN(TagName) AS TagLength, COUNT(Id) ...

aug 3 10
717 views

WITH c AS ( SELECT LEN(TagName) AS TagLength, COUNT(Id) ...

aug 3 10
819 views

SELECT LEN(TagName) AS 'Tag Length', COUNT(*) OVER (PART...

aug 3 10
788 views

SELECT LEN(TagName), COUNT(*) OVER (PARTITION BY LEN(Tag...

aug 3 10
766 views

SELECT COUNT(*) OVER (PARTITION BY LEN(TagName)) FROM Tags

aug 3 10
768 views

SELECT COUNT(Id) OVER (PARTITION BY LEN(TagName)) FROM T...

aug 3 10
754 views

SELECT AVG(LEN(TagName)) OVER (PARTITION BY LEN(TagName)...

aug 3 10
770 views

SELECT SUM(LEN(TagName)) OVER (PARTITION BY LEN(TagName)...

aug 3 10
742 views

Up vs Down votes by hour of day for Answers

aug 2 10
709 views

select DisplayName from Users where Reputation = 0

aug 2 10
725 views

select DisplayName from Users where Reputation = 1

aug 2 10
696 views

select DisplayName from Users where Reputation < 1

aug 2 10
724 views

select DisplayName from Users where Reputation < 0

aug 2 10
695 views

select DisplayName from Users where Reputation < 2

aug 2 10
697 views

select DisplayName from Users where Reputation < 100

aug 2 10
799 views

Top 500 answerers on the site

aug 2 10
771 views

Top 500 answerers on the site

aug 2 10
705 views

SELECT * FROM PostTags WHERE PostId = 17591

aug 2 10
784 views

SELECT users.DisplayName, postTypeId, voteTypes.name, COU...

aug 2 10
732 views

WITH IdPostTags AS ( SELECT ROW_NUMBER() OVER(ORDER BY P...

aug 2 10
737 views

SELECT * FROM PostTags pt1 INNER JOIN PostTags pt2 ON pt...

aug 2 10
767 views

SELECT TOP 5 Posts.Id AS 'Post Link', Tags.TagName FROM ...

aug 2 10
713 views

SELECT TOP 5 Posts.Id AS 'Post Link', Tags.TagName FROM ...

aug 2 10
737 views

SELECT TOP 5 Id AS 'Post Link', PostTags.* FROM Posts IN...

aug 2 10
762 views

SELECT TOP 1 Id AS 'Post Link' FROM Posts INNER JOIN Pos...

aug 2 10
713 views

SELECT TOP 1 Id AS 'Post Link' FROM Posts

aug 2 10
797 views

SELECT TOP 1 Id AS 'Question Link' FROM Posts

aug 2 10
756 views

First 200 users created in 2009

aug 2 10
804 views

First 200 users created in 2009

aug 2 10
749 views

First 200 users created in 2009

aug 2 10
746 views

SELECT TOP 50 Id, PostTypeId, CreationDate, Score FROM P...

aug 2 10
720 views

SELECT TOP 50 * FROM Posts;

aug 2 10
761 views

SELECT CONVERT(datetime, 'Jan 1 2010 11:00 AM'), CONVERT(...

aug 2 10
840 views

SELECT 'Jan 1, 2010 11:00 AM', 'Jan 1, 2010, 1:00 PM'

aug 2 10
861 views

First 200 users created in 2009

aug 2 10 Kip
839 views

First 200 users created in 2009

aug 2 10 Kip
878 views

select top 200 creationdate, datepart(hh, creationdate) a...

aug 2 10 Kip
938 views

First 200 users created in 2009

aug 2 10
799 views

select top 200 creationdate, datepart(hh, creationdate) a...

aug 2 10
751 views

select top 50 creationdate, datepart(hh, creationdate) as...

aug 2 10
787 views

select top 50 creationdate, datepart(hh, creationdate) as...

aug 2 10
782 views

select top 50 creationdate, datepart(hh, creationdate) as...

aug 2 10
761 views

select top 50 creationdate, datepart(hh, creationdate) as...

aug 2 10
809 views

select top 40 *, users.reputation, users.displayname fro...

aug 2 10
802 views

select top 50 creationdate, id as [Post Link] from posts ...

aug 2 10
830 views

select top 40 posts.*, users.reputation, users.displayna...

aug 2 10
836 views

SELECT * from votetypes

aug 2 10 pmcelhaney
802 views

SELECT * from votes where userid = 437

aug 2 10 pmcelhaney
834 views

SELECT count(id) from votes where userid = 437

aug 2 10 pmcelhaney

30 50 100 per page

2,279,319

queries

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

16k questions

20k answers

45k comments

506 tags

dec 7 most recent