Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

606 views

select * from users where displayname = 'Paul Kearney (p...

jan 3 11
581 views

DECLARE @UserId int = ##UserId## SELECT Score , Count(id...

jan 3 11 conradfrix
619 views

select Id as [User Link], Reputation, AboutMe, Location ...

jan 3 11 sam.saffron
640 views

select Id as [User Link], Reputation, AboutMe, Location ...

jan 3 11 sam.saffron
1

5k views

My Answer Score Distribution

jan 3 11 conradfrix
644 views

select Id as [User Link], Reputation, AboutMe from Users...

jan 3 11 sam.saffron
603 views

DECLARE @UserId int = ##UserId## SELECT Score FROM Posts...

jan 3 11 conradfrix
604 views

DECLARE @UserId int = ##UserId## SELECT * FROM Posts WHERE

jan 3 11 conradfrix
602 views

select * from Users where Location like '%new york%' or l...

jan 3 11 sam.saffron
639 views

select * from Users where Location like '%new york%' or l...

jan 3 11 sam.saffron
639 views

select * from Users where Location like '%new york%'

jan 3 11 sam.saffron
635 views

Select top 100 id [Post Link] , posttypeid from posts

jan 3 11 conradfrix
641 views

select * from Users where Location like '%ny%'

jan 3 11 sam.saffron
624 views

Select id [Link] , posttypeid from posts

jan 3 11 conradfrix
637 views

Select id [link] , posttypeid from posts

jan 3 11 conradfrix
601 views

Select id [post link] , posttypeid from posts

jan 3 11 conradfrix
597 views

SELECT TOP 10 * FROM users

jan 3 11
618 views

SELECT TOP 10 * FROM votetypes

jan 3 11
1

4.8k views

Question distribution by number of views

jan 3 11 kelly.french
675 views

Question distribution by number of views

jan 3 11 kelly.french
742 views

Question distribution by number of views

jan 3 11 kelly.french
691 views

Question distribution by number of views

jan 3 11 kelly.french
707 views

Question distribution by number of views

jan 3 11 kelly.french
664 views

Question distribution by number of views

jan 3 11 kelly.french
740 views

Question distribution by number of views

jan 3 11 kelly.french
705 views

Question distribution by number of views

jan 3 11 kelly.french
619 views

Downvotes by User

jan 3 11 kelly.french
621 views

Select count(*) from Votes where UserId = ##UserId## and ...

jan 3 11 kelly.french
651 views

Select count(*) from Votes where UserId = ##UserId## and ...

jan 3 11 kelly.french
597 views

Select* from Votes where UserId = ##UserId##

jan 3 11 kelly.french
635 views

Select VoteTypeId, count(*) as Votes from Votes where Use...

jan 3 11 kelly.french
646 views

Select distinct VoteTypeId, count(*) as Votes from Votes ...

jan 3 11 kelly.french
654 views

Select distinct VoteTypeId from Votes --where UserId = ##...

jan 3 11 kelly.french
652 views

Select distinct VoteTypeId from Votes --where UserId = ##...

jan 3 11 kelly.french
617 views

Select distinct VoteTypeId from Votes where UserId = ##Us...

jan 3 11 kelly.french
578 views

Select * from Votes where UserId = ##UserId##

jan 3 11 kelly.french
612 views

select PostId as [Post Link] from Comments where Text li...

jan 3 11 mmyers
676 views

select * from Comments where Text like '%just to make th...

jan 3 11 mmyers
667 views

Question distribution by number of views

jan 3 11 kelly.french
650 views

select * from Comments where Text like '%sideways%'

jan 3 11 mmyers
1

7k views

Question distribution by number of views

jan 3 11 kelly.french
570 views

select sum(case when ViewCount > 100000 then 1 end) as Po...

jan 3 11
601 views

select sum(case when ViewCount > 100000 then 1 end) as Po...

jan 3 11
576 views

Questions by Views

jan 3 11
606 views

select p.* from ( select postTypeId , id , ROW_NUMBER() o...

jan 3 11
578 views

select * from ( select postTypeId , id , ROW_NUMBER() ove...

jan 3 11
629 views

select top 1000 sum(case when ViewCount > 100000 then 1 e...

jan 3 11
595 views

Questions by Views

jan 3 11
597 views

Questions by Views

jan 3 11
604 views

Questions by Views

jan 3 11

30 50 100 per page

2,286,566

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 18 most recent