Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

Select VoteTypeId, COUNT(Id) FROM Votes WHERE CreationDat...

jan 28 LasseG
0 views

Select VoteTypeId, COUNT(Id) FROM Votes GROUP BY VoteTypeId

jan 28 LasseG
0 views

select count(*), count(distinct(OwnerUserId)) from Posts ...

jan 28
1 view

SELECT * FROM (SELECT TOP 1 create_date AS [Voted On], -...

jan 28 Martijn Pieters
0 views

SELECT * FROM (SELECT TOP 1 create_date AS [Voted On], -...

jan 28 Martijn Pieters
1 view

SELECT * FROM (SELECT TOP 1 create_date AS [Voted On], -...

jan 28 Martijn Pieters
1 view

select count(*), count(distinct(OwnerUserId)) from Posts;

jan 28
0 views

select count(*), count(distinct(OwnerUserId)) from Posts;

jan 28
2 views

SELECT * FROM (SELECT TOP 1 create_date AS [Voted On], -...

jan 28 Martijn Pieters
2 views

SELECT TOP 1 create_date AS [Voted On], -1 AS [User Link]...

jan 28 Martijn Pieters
4 views

Number of posts in Math Stack Overflow that are over the 30k soft character limit

jan 28
3 views

Number of posts in Math Stack Overflow that are over the 30k soft character limit

jan 28
5 views

Number of posts in Stack Overflow that are over the 30k soft character limit

jan 28
3 views

SELECT TOP 1 create_date, -1 FROM sys.databases WHERE nam...

jan 28 Martijn Pieters
5 views

Number of posts in Stack Overflow that are over the 30k soft character limit

jan 28
5 views

Number of posts in Stack Overflow that are over the 30k soft character limit

jan 28
3 views

Number of posts in Math Stack Overflow that are over the 30k soft character limit

jan 28
4 views

Number of posts in Math Stack Overflow that are over the 30k soft character limit

jan 28
3 views

select count(*) as count from posts where postTypeId = 1

jan 28
3 views

select top 1 create_date from sys.databases where name no...

jan 28 Martijn Pieters
3 views

WITH top_users AS (SELECT TOP 10 ownerUserId, SUM(score) ...

jan 28
4 views

WITH top_users AS (SELECT TOP 10 ownerUserId, SUM(score) ...

jan 28
10 views

SELECT Location, COUNT(*) FROM Users WHERE LOWER(Location...

jan 28 Roman R.
8 views

WITH top_users AS (SELECT TOP 10 ownerUserId, SUM(score) ...

jan 28
8 views

select * from sys.databases order by create_date desc

jan 28 Martijn Pieters
13 views

example

jan 28
8 views

select create_date , name from sys.databases order by cr...

jan 28 Martijn Pieters
10 views

SELECT Location, COUNT(*) FROM Users WHERE LOWER(Location...

jan 28 Roman R.
10 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.
10 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.
1

19 views

Who bookmarked a post?

jan 28 Martijn Pieters
8 views

select top 100 *, concat('https://stackoverflow.com/users...

jan 28
34 views

SELECT u.Id [User Link], u.Reputation, u.CreationDate, u....

jan 28 LasseG
14 views

example

jan 28
8 views

WITH top_users AS (SELECT TOP 10 ownerUserId, SUM(score) ...

jan 28
14 views

Details by Tag

jan 28 bwest
14 views

Details by Tag

jan 28 bwest
8 views

SELECT * FROM Posts

jan 28
10 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.
10 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.
10 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.
34 views

SELECT u.Id [User Link], u.Reputation, u.CreationDate, u....

jan 28 LasseG
10 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.
10 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.
9 views

SELECT TOP 10 ownerUserId, SUM(score) AS sum_score, AVG(s...

jan 28
1

19 views

Who bookmarked a post?

jan 28 Martijn Pieters
10 views

select top 10 ownerUserId AS userId, SUM(score) AS totalS...

jan 28
40 views

Who bookmarked a post?

jan 28 Martijn Pieters
10 views

SELECT COUNT(*) FROM Users WHERE LOWER(Location) LIKE LOW...

jan 28 Roman R.
10 views

SELECT Score FROM Posts WHERE SCORE = '1';

jan 28
10 views

select top 10 ownerUserId AS userId, SUM(score) AS totalS...

jan 28
18 views

example

jan 28
11 views

SELECT TOP 10 p.OwnerUserId AS top_10_candidates_id,u.Dis...

jan 28
11 views

Select * from SuggestedEditVotes Where UserId = 9190135

jan 28 LasseG

30 50 100 per page

1,875,031

queries

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

433 questions

929 answers

2.4k comments

96 tags

jan 23 most recent