Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

735 views

select * from Posts inner join Posts p on Posts.Id= p.p...

nov 25 10 z
734 views

SELECT COUNT(*) FROM POSTS;

nov 25 10
710 views

declare @questions int set nocount on select @question...

nov 25 10
672 views

SELECT COUNT(*);

nov 25 10
695 views

select * from Users where Reputation>=1000;

nov 25 10
692 views

select * from Users where EmailHash='b338e877fffff7a61d9...

nov 25 10
643 views

select * from Users where EmailHash='4758e6fdb48345ff5dc...

nov 25 10
639 views

select * from Users where EmailHash='7008a3be585decb7b82...

nov 25 10
651 views

select * from Users where EmailHash='[email protected]';

nov 25 10
646 views

select * from Users where EmailHash='c38fd9074fb072551c0...

nov 25 10
648 views

select * from Users where EmailHash='27f0e0417bcb011604e...

nov 25 10
734 views

select * from Users where EmailHash='94e2904aff07266d1be...

nov 25 10
721 views

select Reputation from Users where EmailHash='94e2904aff...

nov 25 10
689 views

select * from Users where DisplayName = 'irishe'

nov 25 10
709 views

select * from Users where DisplayName = 'IrisHe'

nov 25 10
633 views

select * from Users where Id = 349629

nov 25 10
698 views

select * from posts where posts.posttypeId = 3

nov 25 10 z
748 views

select * from posts where posts.body like 'Oh Eggs....E...

nov 25 10 z
752 views

select * from posts where posts.body='Oh Eggs....Every ...

nov 25 10 z
684 views

select score, body from posts where posts.parentId = 4 o...

nov 25 10 z
630 views

select score, body from posts where posts.parentId = 4 o...

nov 25 10 z
662 views

select body from posts where posts.parentId = 4 order by...

nov 25 10 z
694 views

select body from posts where posts.parentId = 4 order by...

nov 25 10 z
667 views

select body from posts where posts.parentId = 4

nov 25 10 z
642 views

SELECT top 10 * FROM Posts q INNER JOIN Posts a ON q.Acce...

nov 25 10
675 views

SELECT top 10 * FROM Posts q INNER JOIN Posts a ON q.Acce...

nov 25 10
655 views

SELECT top 10 * FROM Posts q INNER JOIN Posts a ON q.Acce...

nov 25 10
727 views

select max(score) from Posts where posts.posttypeid=3

nov 25 10 z
641 views

select posttypeid, tags, score from Posts where posts.pos...

nov 25 10 z
682 views

select posttypeid, tags, score from Posts where posts.pos...

nov 25 10 z
650 views

select posttypeid, tags, score from Posts where posts.pos...

nov 25 10 z
739 views

select avg(Posts.score) from Posts where posts.posttypeid=1

nov 25 10 z
660 views

select avg(Posts.score) from Posts where posts.posttypeid=2

nov 25 10 z
739 views

select * from Posts where posts.posttypeid=3

nov 25 10 z
669 views

select * from Posts where posts.Score = (select max(posts...

nov 25 10 z
687 views

select max(Posts.score) from Posts where posts.PostTypeId=1

nov 25 10 z
655 views

select max(Posts.score) from Posts where posts.PostTypeId=2

nov 25 10 z
655 views

SELECT * FROM Posts q INNER JOIN Posts a ON q.AcceptedAn...

nov 25 10 Jon Seigel
685 views

SELECT * FROM Posts q INNER JOIN Posts a ON a.AcceptedAn...

nov 25 10 Jon Seigel
667 views

SELECT * FROM Posts q INNER JOIN Posts a ON a.AcceptedAn...

nov 25 10 Jon Seigel
708 views

SELECT * FROM Posts q INNER JOIN Posts a ON a.AcceptedAn...

nov 25 10 Jon Seigel
696 views

SELECT column_name, data_type FROM information_schema.col...

nov 24 10 z
693 views

select count(Distinct Id) from users

nov 24 10 z
723 views

select count(Distinct TagId) from posttags

nov 24 10 z
697 views

select count(Distinct TagId) from posttags

nov 24 10 z
676 views

select count(*) from posts where posts.PostTypeId= 3

nov 24 10 z
654 views

select Id,AcceptedAnswerId,Body,LastActivityDate from Po...

nov 24 10
657 views

select AcceptedAnswerId,Body,LastActivityDate from Posts...

nov 24 10
682 views

select jonsAnswer.Score as JonsScore,jonsAnswer.ParentId ...

nov 24 10
618 views

select jonsAnswer.Score as JonsScore,jonsAnswer.ParentId ...

nov 24 10
650 views

select count(*) from posts where posts.PostTypeId= 1

nov 24 10 z
713 views

select distinct posttypeId from posts

nov 24 10 z
729 views

SELECT * FROM PostHistory

nov 24 10
673 views

select displayname, age, aboutme from users where age < 1...

nov 24 10
691 views

SELECT c.Text, P.ParentId FROM Comments AS c JOIN Posts ...

nov 24 10
695 views

SELECT Text FROM Comments WHERE UserId = 12567 AND Text ...

nov 24 10
677 views

SELECT Body FROM Posts WHERE OwnerUserId = 12567 AND Bod...

nov 24 10
695 views

SELECT Body FROM Posts WHERE OwnerUserId = 12567 AND Bod...

nov 24 10
672 views

SELECT Body FROM Posts WHERE OwnerUserId = 12567 AND Bod...

nov 24 10
656 views

SELECT Body FROM Posts WHERE OwnerUserId = 12567 AND Bod...

nov 24 10
678 views

SELECT Body FROM Posts WHERE OwnerUserId = 12567 AND Bod...

nov 24 10
712 views

SELECT Body FROM Posts WHERE OwnerUserId = 12567

nov 24 10
745 views

select displayname, age, aboutme from users where age > 5...

nov 24 10
744 views

select displayname, age from users where age > 50 order b...

nov 24 10
675 views

select displayname, age from users where age > 50 order b...

nov 24 10
689 views

select displayname, age from users where age > 50

nov 24 10
676 views

select max(age) from users

nov 24 10
728 views

select users.displayname, max(age) from users group by di...

nov 24 10
731 views

select users.displayname, age from users order by age

nov 24 10
759 views

select users.displayname, posts.title, posts.tags from us...

nov 24 10
669 views

select users.displayname, posts.title, posts.tags from us...

nov 24 10
659 views

select users.displayname, posts.title, posts.tags from us...

nov 24 10
699 views

select users.id, posts.title, posts.tags from users,posts...

nov 24 10
689 views

select users.id, posts.title, posts.tags from users,posts...

nov 24 10
698 views

select * from users,posts where users.displayname like 'v...

nov 24 10
703 views

select * from users,posts where users.displayname like 'o...

nov 24 10
692 views

select * from users,posts where users.displayname like 'o...

nov 24 10
748 views

select * from users where users.displayname like 'oak'

nov 24 10
739 views

SELECT * FROM POsts

nov 24 10 diegueus9
677 views

select * from Posts where Id < 2000

nov 24 10
717 views

select * from Users where DisplayName in ('apoclast','hux...

nov 24 10
705 views

select * from Users where DisplayName in ('apoclast','hux...

nov 24 10
724 views

select * from Users where DisplayName in ('apoclast','hux...

nov 24 10
764 views

select * from Users where DisplayName = 'apoclast'

nov 24 10
820 views

SELECT p1.Id AS [Post Link], 'a' AS [Type], p2.Body AS B...

nov 24 10 ww.galen
810 views

SELECT p1.Id AS [Post Link], p2.Id AS [Post Link], p2.Bo...

nov 24 10 ww.galen
753 views

SELECT p1.Id AS [Post Link], p2.Body AS Body FROM Posts ...

nov 24 10 ww.galen
785 views

How Many Edits Until Copy Editor

nov 24 10
740 views

How Many Edits Until Copy Editor

nov 24 10
738 views

select top 20 * from users order by reputation desc

nov 24 10
744 views

select top 20 * from users order by reputation

nov 24 10
711 views

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

nov 24 10
722 views

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

nov 24 10
723 views

select top 10 * from users order by id

nov 24 10
725 views

DECLARE @UserId int = 252697--<-- Change this by your use...

nov 24 10
770 views

DECLARE @UserId int = ##UserId## SELECT TOP 20 COUNT(*) ...

nov 24 10 kees
740 views

DECLARE @UserId int = ##UserId## SELECT TOP 20 COUNT(*) ...

nov 24 10 kees
773 views

How many upvotes do I have for each tag?

nov 24 10
802 views

How many upvotes do I have for each tag?

nov 24 10
754 views

How many upvotes do I have for each tag?

nov 24 10

30 50 100 per page