Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

20 views

SELECT COUNT(*) AS UserCount FROM Users;

jan 14
9 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
20 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
21 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
21 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
20 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
20 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
18 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
20 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
19 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
19 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
18 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
21 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
22 views

SELECT COUNT(*) --AS UserCount FROM Users;

jan 14
20 views

select count(id) from Users

jan 14
32 views

news posts

jan 14
31 views

news posts

jan 14
21 views

SELECT COUNT(*) FROM Posts;

jan 14
23 views

news posts

jan 14
31 views

news posts

jan 14
32 views

news posts

jan 14
19 views

SELECT COUNT(*) FROM information_schema.tables;

jan 14
22 views

SELECT COUNT(*) FROM Users;

jan 14
20 views

SELECT COUNT(*) FROM information_schema.tables;

jan 14
12 views

SELECT COUNT(*) FROM information_schema.tables WHERE tabl...

jan 14
20 views

SELECT COUNT(*) FROM information_schema.tables WHERE tabl...

jan 14
22 views

SELECT COUNT(*) FROM information_schema.tables WHERE tabl...

jan 14
19 views

SELECT COUNT(*) FROM information_schema.tables WHERE tabl...

jan 14
21 views

SELECT COUNT(*) FROM information_schema.tables WHERE tabl...

jan 14
10 views

select * from postnotices

jan 14
20 views

select count(distinct location) from Users

jan 14
10 views

select distinct location from Users

jan 14
20 views

select distinct location from Users

jan 14
20 views

select distinct location from Users

jan 14
18 views

SELECT TOP 10 * FROM Posts WHERE PostTypeId = 1 AND Accep...

jan 14
9 views

SELECT TOP 10 * FROM Posts

jan 14
18 views

SELECT TOP 10 * FROM Posts

jan 14
18 views

SELECT top 10 * from Posts where FavoriteCount is not null

jan 14
8 views

SELECT top 10 * from Posts

jan 14
18 views

SELECT top 10 * from Posts

jan 14
10 views

SELECT top 10 * from Posts

jan 14
18 views

select TOP 10 * from Posts where PostTypeId = 1 and Acce...

jan 14
19 views

SELECT TOP 10 * FROM Posts ORDER BY CreationDate DESC;

jan 14
9 views

SELECT TOP 10 * FROM Posts;

jan 14
19 views

SELECT TOP 10 * FROM Posts;

jan 14
18 views

SELECT TOP 10 * FROM Posts;

jan 14
9 views

SELECT * FROM PostNotices WHERE PostId = 387115

jan 14 Glorfindel
9 views

select * from users;

jan 14
17 views

DECLARE @UserId int = ##UserId## SELECT Comments.Score,...

jan 14
18 views

DECLARE @UserId int = ##UserId## SELECT Comments.Id as...

jan 14
9 views

DECLARE @UserId int = ##UserId## SELECT Comments.Score,...

jan 14
18 views

DECLARE @UserId int = ##UserId## SELECT Comments.Score,...

jan 14
17 views

DECLARE @UserId int = ##UserId## SELECT Comments.Score,...

jan 14
7 views

declare @Features table (FeatureID int, ParentID int, Fea...

jan 14
10 views

declare @Features table (FeatureID int, ParentID int, Fea...

jan 14
16 views

select * from users where location like '%srael%' and abo...

jan 14
15 views

select * from users where location like '%srael%' and abo...

jan 14
8 views

select * from users where location like 'srael' and about...

jan 14
15 views

select * from users where location like 'srael' and about...

jan 14
16 views

select * from users where location like 'srael' and about...

jan 14
8 views

select top 10 * from Posts

jan 14
10 views

select * from Posts;

jan 14
13 views

select * from Users order by Reputation desc;

jan 14
15 views

select * from Users order by Reputation;

jan 14
8 views

select * from Users where DownVotes > 100;

jan 14
15 views

select * from Users where DownVotes > 100;

jan 14
13 views

select * from Users where DownVotes > 100;

jan 14
209 views

SELECT TOP 1000 * FROM CloseAsOffTopicReasonTypes;

jan 14 Lasklu
10 views

SELECT CONCAT('https://askubuntu.com/q/', PostId, '#comme...

jan 14 Starship
46 views

SELECT CONCAT('https://superuser.com/q/', PostId, '#comme...

jan 14 Starship
46 views

SELECT CONCAT('https://superuser.com/q/', PostId, '#comme...

jan 14 Starship
46 views

SELECT CONCAT('https://superuser.com/q/', PostId, '#comme...

jan 14 Starship
46 views

SELECT CONCAT('https://superuser.com/q/', PostId, '#comme...

jan 14 Starship
31 views

Performance

jan 14 jon.doe46835
46 views

SELECT CONCAT('https://superuser.com/q/', PostId, '#comme...

jan 14 Starship
8.2k views

Comments saying thanks to a user

jan 14 Starship
209 views

SELECT TOP 1000 * FROM Votes;

jan 14 Lasklu
8.2k views

Comments saying thanks to a user

jan 14 Starship
209 views

SELECT TOP 1000 * FROM VoteTypes;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM Users;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM Tags;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM TagSynonyms;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM SuggestedEdits;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM SuggestedEditVotes;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM ReviewTasks;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM ReviewTaskTypes;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM ReviewTaskStates;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM ReviewTaskResults;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM ReviewTaskResultTypes;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM ReviewRejectionReasons;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM PostsWithDeleted;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM Posts;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM PostTypes;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM PostTags;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM PostNotices;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM PostNoticeTypes;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM PostLinks;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM PostHistoryTypes;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM PostHistory;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM PostFeedback;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM PendingFlags;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM FlagTypes;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM Comments;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM CloseReasonTypes;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM CloseAsOffTopicReasonTypes;

jan 14 Lasklu
209 views

SELECT TOP 1000 * FROM Badges;

jan 14 Lasklu
209 views

SELECT TOP 100 * FROM Badges;

jan 14 Lasklu
10 views

select count(*) from posts

jan 14
12 views

create table #PetOwner ( Id int identity(3,1) , Na...

jan 14
13 views

select * from Posts

jan 14
8.2k views

Comments saying thanks to a user

jan 14 Starship
8.2k views

Comments saying thanks to a user

jan 14 Starship
8.2k views

Comments saying thanks to a user

jan 14 Starship
8.2k views

Comments saying thanks to a user

jan 14 Starship
8.2k views

Comments saying thanks to a user

jan 14 Starship
8.2k views

Comments saying thanks to a user

jan 14 Starship
8.2k views

Comments saying thanks to a user

jan 14 Starship
13 views

select * from PostTypes

jan 14
203 views

Select top(100) * from Users;

jan 14 jon.doe46833
203 views

with target_tags as (select ISNULL(TargetTagName, TagName...

jan 14 jon.doe46833
203 views

with target_tags as (select ISNULL(TargetTagName, TagName...

jan 14 jon.doe46833
203 views

with target_tags as (select ISNULL(TargetTagName, TagName...

jan 14 jon.doe46833
203 views

with target_tags as (select ISNULL(TargetTagName, TagName...

jan 14 jon.doe46833
203 views

with target_tags as (select ISNULL(TargetTagName, TagName...

jan 14 jon.doe46833
203 views

with target_tags as (select ISNULL(TargetTagName, TagName...

jan 14 jon.doe46833
203 views

select ISNULL(TargetTagName, TagName) as tag_name, count(*)

jan 14 jon.doe46833
203 views

select count(*) from Posts p inner join PostTags pt on p....

jan 14 jon.doe46833
203 views

select ISNULL(TargetTagName, TagName) as tag_name, count(*)

jan 14 jon.doe46833
203 views

select count(*) from Posts p inner join PostTags pt on p....

jan 14 jon.doe46833
203 views

select count(*) from Posts p inner join PostTags pt on p....

jan 14 jon.doe46833

30 50 100 per page

2,285,588

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