Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

936 views

select top 15 u.Id as [User Link], count(p.Id) as Questio...

jul 2 10 Simon Brown
989 views

Popularity of Tags by questions per month.

jul 2 10
970 views

select * from Users where DisplayName = 'mavera'

jul 2 10 mavera
1.1k views

select num.TagName as Tag, row_number() over (order by ra...

jul 2 10
983 views

select u.Age, sum(u.Reputation) from Users u group by u.Age

jul 2 10 Simon Brown
1k views

select sum(u.Reputation) from Users u

jul 2 10 Simon Brown
900 views

Boxed Users

jul 1 10
979 views

Boxed Users

jul 1 10 jjnguy
964 views

Boxed Users

jul 1 10 jjnguy
3

7.4k views

Boxed Users

jul 1 10 jjnguy
977 views

Boxed Users

jul 1 10 jjnguy
912 views

Boxed Users

jul 1 10 jjnguy
977 views

Boxed Users

jul 1 10 jjnguy
1k views

Boxed Users

jul 1 10 jjnguy
928 views

Boxed Users

jul 1 10 jjnguy
985 views

Boxed Users

jul 1 10 jjnguy
982 views

Boxed Users

jul 1 10 jjnguy
965 views

Track excessive Downvoters

jul 1 10
4.5k views

Track excessive Downvoters

jul 1 10 radius
948 views

SELECT Id, Reputation, DisplayName, UpVotes, DownVotes, ...

jul 1 10 radius
927 views

SELECT Id, Reputation, DisplayName, UpVotes, DownVotes, ...

jul 1 10 radius
987 views

SELECT Id, Reputation, DisplayName, UpVotes, DownVotes, ...

jul 1 10 radius
962 views

SELECT Id, Reputation, DisplayName, UpVotes, DownVotes, ...

jul 1 10 radius
1k views

SELECT Id, Reputation, DisplayName, UpVotes, DownVotes, ...

jul 1 10 radius
971 views

SELECT Id, Reputation, DisplayName, UpVotes, DownVotes, ...

jul 1 10 radius
1.1k views

SELECT * FROM Users ORDER BY DownVotes desc

jul 1 10 radius
960 views

select * from Users where Location like 'Israel' order b...

jul 1 10
992 views

select * from Users where Location like 'Israel' order by...

jul 1 10
942 views

select * from Users where Location like 'Israel' order b...

jul 1 10
884 views

select * from Users where Location like 'Israel' order by...

jul 1 10
936 views

select * from Users where Location like 'Israel' order b...

jul 1 10
927 views

select * from Users where Location like 'Israel'

jul 1 10
1k views

select * from Users where Id = 45

jul 1 10
1k views

select count(v.id), vt.name from votes v inner join vote...

jul 1 10
964 views

SELECT p2.OwnerUserId, count(*) as count FROM Posts p1 LE...

jul 1 10
1k views

SELECT 'Ja dit klopt', p2.OwnerUserId, count(*) as count ...

jul 1 10
1k views

SELECT p2.OwnerUserId, count(*) as count FROM Posts p1 LE...

jul 1 10
1k views

SELECT p1.OwnerUserId, count(*) as count FROM Posts p1 WH...

jul 1 10
961 views

SELECT p1.OwnerUserId, count(*) as count FROM Posts p1 WH...

jul 1 10
984 views

SELECT p1.OwnerUserId, count(*) as count FROM Posts p1 WH...

jul 1 10
1k views

SELECT p1.OwnerUserId, count(*) as count FROM Posts p1 LE...

jul 1 10
990 views

SELECT p1.OwnerUserId, count(*) FROM Posts p1 LEFT JOIN P...

jul 1 10
1.1k views

How Many Edits Until Strunk & White

jul 1 10 Piskvor
1.1k views

SELECT * FROM Posts WHERE Tags like '%<haskell>%';

jul 1 10
932 views

SELECT * FROM Posts WHERE Id = 2799588

jul 1 10
940 views

SELECT * FROM Posts WHERE Id = 3157154

jul 1 10
951 views

SELECT * FROM Posts WHERE Id = 3157514

jul 1 10
879 views

SELECT * FROM Posts WHERE Id = 3157514

jul 1 10
996 views

SELECT * FROM Users WHERE Age > 60

jul 1 10 David M
1k views

select count(*) --Name, Count(*) from badges where UserId...

jul 1 10 psasik
925 views

select Name, Count(*) from badges where UserId = 47550 gr...

jul 1 10 psasik
905 views

select Name, Count(*) from badges where UserId = 47550 gr...

jul 1 10 psasik
953 views

select Name, Count(*) from badges where UserId = 47550 gr...

jul 1 10 psasik
961 views

select * from badges where UserId = 47550

jul 1 10 psasik
979 views

select top 1000 location from users group by location

jul 1 10 sopel
978 views

select top 1000 location from users

jul 1 10 sopel
971 views

select count(DISTINCT Location) from Users as u group b...

jul 1 10
975 views

select count(DISTINCT Location) from Users as u where Lo...

jul 1 10
973 views

select count(DISTINCT Location) from Users as u where Lo...

jul 1 10
971 views

select Location, count(1) from Users as u where Location...

jul 1 10
1k views

select Location from Users as u where Location IN ('Germ...

jul 1 10
964 views

select count(Location), u.Location from Users as u where...

jul 1 10
1k views

select count(Location), Location from Users where Locati...

jul 1 10
994 views

select Location, count(Location) from Users where Locati...

jul 1 10
912 views

select count(Location) from Users where Location IN ('Ge...

jul 1 10
1k views

select count(Location) from Users where Location IN ('Ge...

jul 1 10
1.1k views

select count(Location) from Users where Location IN ('DE...

jul 1 10
1k views

select count(Location) from Users group by Location

jul 1 10
988 views

select count(Location) from Users where id < 128

jul 1 10
953 views

select Location from Users where id < 128

jul 1 10
993 views

select * from Users where Location LIKE '%New%'

jul 1 10
950 views

select * from Users where id = 4

jul 1 10
910 views

select * from Users where id = 2

jul 1 10
900 views

select * from Users where id = 46773

jul 1 10
1k views

select votes.postid, count(*), avg(1) from votes, posts...

jun 30 10
909 views

select votes.postid, count(*) from votes, posts, users ...

jun 30 10
958 views

select votes.postid, count(*) from votes, posts, users ...

jun 30 10
961 views

select votes.* from votes, posts, users where votes.pos...

jun 30 10
932 views

select top 5 votes.* from votes, posts, users where vot...

jun 30 10
1.2k views

Field Types

jun 30 10 Simon Brown
361 views

Field Types

jun 30 10 Simon Brown
973 views

Storing variables from queries in stored procedures

jun 30 10
1.1k views

Storing variables from queries in stored procedures

jun 30 10
967 views

DECLARE @UserId uniqueidentifier; SELECT @UserId = CONVE...

jun 30 10
972 views

SELECT CONVERT(uniqueidentifier, '00000000-0000-0000-000...

jun 30 10
897 views

select * from Users where displayName like ('%Greener%')

jun 30 10
927 views

select * from Users where id like ('%Greener%')

jun 30 10
949 views

select * from Users where id like ('%greener%')

jun 30 10
879 views

select * from posts where ViewCount < 50

jun 30 10
1k views

Combine varchar column with int column

jun 30 10
935 views

SELECT TOP 5 CAST(id AS varchar(100)) + ' ' + title FROM...

jun 30 10
901 views

SELECT TOP 5 id FROM Posts;

jun 30 10
969 views

select top 15 u.Id as [User Link], (select count(b.Name) ...

jun 30 10 Simon Brown
991 views

select u.Id as [User Link], (select count(b.Name) from Ba...

jun 30 10 Simon Brown
893 views

Test

jun 30 10
934 views

Test

jun 30 10
930 views

select top 20 * from comments order by score

jun 30 10
882 views

select * from comments order by score

jun 30 10
1k views

Users with most answers

jun 30 10
2.5k views

Users with most answers

jun 30 10
2.7k views

Users with most answers

jun 30 10
2.7k views

Users with most answers

jun 30 10
2.7k views

Users with most answers

jun 30 10
2.9k views

Users with most answers

jun 30 10
2.4k views

Users with most answers

jun 30 10
2.3k views

Users with most answers

jun 30 10
3

20k views

Users with most answers

jun 30 10
2.9k views

Users with most answers

jun 30 10
2.7k views

Users with most answers

jun 30 10
3.2k views

Users with most answers

jun 30 10
2.9k views

Users with most answers

jun 30 10
1.1k views

Users with most answers

jun 30 10
893 views

Users with most answers

jun 30 10
937 views

Users with most answers

jun 30 10
951 views

select * from comments where text LIKE 's/%'

jun 30 10

30 50 100 per page

2,285,486

queries

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

66 questions

131 answers

229 comments

73 tags

jan 24 24 most recent