Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

0 views

select distinct year(creationdate) from posts order by ye...

dec 9
0 views

select creationdate from posts

dec 9
0 views

select * from posts

dec 9
0 views

SELECT year(creationdate) - lag(year(creationdate)) OVER ...

dec 9
0 views

select owneruserid, DATEDIFF(year,lag(CreationDate) over ...

dec 9
1 view

SELECT lag(year(creationdate)) OVER (ORDER BY creationDat...

dec 9
2 views

SELECT TOP 10000 lag(year(creationdate)) OVER (ORDER BY c...

dec 9
2 views

SELECT TOP 10000 year(creationdate) - lag(year(creationda...

dec 9
2 views

select owneruserid, DATEDIFF(year,lag(CreationDate) over ...

dec 9
1

13 views

Fourth

dec 9 Kamushek
1

13 views

Fourth

dec 9 Kamushek
2 views

SELECT owneruserid, DATEDIFF(year,lag(CreationDate) over ...

dec 9
1

13 views

Fourth

dec 9 Kamushek
1

13 views

Fourth

dec 9 Kamushek
1

13 views

Fourth

dec 9 Kamushek
2 views

SELECT TOP 10000 year(creationdate) - lag(year(creationda...

dec 9
5 views

Most viewed questions in a tag

dec 9
1

13 views

Fourth

dec 9 Kamushek
2 views

SELECT TOP 1000 year(creationdate) - lag(year(creationdat...

dec 9
2 views

SELECT TOP 100 year(creationdate) - lag(year(creationdate...

dec 9
2 views

SELECT year(creationdate) - lag(year(creationdate)) OVER ...

dec 9
2 views

SELECT TOP 100 year(creationdate) - lag(year(creationdate...

dec 9
2 views

SELECT year(creationdate) - lag(year(creationdate)) OVER ...

dec 9
2 views

SELECT owneruserid, DATEDIFF(year,lag(CreationDate) over ...

dec 9
1

13 views

Fourth

dec 9 Kamushek
5 views

Most viewed questions in a tag

dec 9
3 views

select count(*) from (select p.owneruserid from posts p g...

dec 9 Kamushek
2 views

select owneruserid from posts p join users u on p.ownerus...

dec 9
2 views

with date_diff (owneruserid, diff) as( select owneruserid,

dec 9
3 views

with date_diff (owneruserid, diff) as( select owneruserid,

dec 9
1

13 views

Fourth

dec 9 Kamushek
3 views

with date_diff (owneruserid, diff) as( select owneruserid,

dec 9
3 views

with date_diff (owneruserid, diff) as( select owneruserid,

dec 9
3 views

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
3 views

with date_diff (owneruserid, diff) as( select owneruserid,

dec 9
3 views

select count(*) from posts

dec 9 Kamushek
3 views

with date_diff (owneruserid, diff) as( select owneruserid,

dec 9
7 views

Most viewed questions in a tag

dec 9
4 views

with date_diff as( select id, owneruserid, creationdate,...

dec 9
3 views

select count(*) from (select p.owneruserid from posts p g...

dec 9 Kamushek
3 views

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
3 views

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
3 views

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
4 views

with date_diff as( select id, owneruserid, creationdate,...

dec 9
4 views

SELECT t1._year, 100.0 * t1._count / t2._count as _per FR...

dec 9
4 views

SELECT t1._year, 100.0 * t1._count / t2._count as _per FR...

dec 9
4 views

SELECT t1._year, 1.0 * t1._count / t2._count as _per FROM...

dec 9
4 views

SELECT t1._year, t1._count / t2._count as _per FROM (SE...

dec 9
4 views

SELECT t1._year, t1._count, t2._count FROM (SELECT Year...

dec 9
4 views

SELECT t1._year, t1._count / t2._count * 100 FROM (SELE...

dec 9
4 views

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
4 views

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
3 views

SELECT t1._year, t1._count FROM (SELECT Year(creationda...

dec 9
3 views

select owneruserid, min(creationdate) from posts group by...

dec 9
3 views

select owneruserid from posts group by owneruserid having...

dec 9
2 views

SELECT t1._year, t1._count / t2._count FROM (SELECT Yea...

dec 9
1 view

select owneruserid from posts group by owneruserid having...

dec 9
1 view

SELECT t1._year, t1._count / t2._count FROM (SELECT Yea...

dec 9
1

13 views

Fourth

dec 9 Kamushek
1 view

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
1 view

SELECT t1._year, t1._count/t2._count FROM (SELECT year(cr...

dec 9
1

13 views

Fourth

dec 9 Kamushek
1 view

SELECT t1._year, t1._count/t2._count FROM (SELECT TOP 100...

dec 9
1 view

SELECT t1._year, t1._count/t2._count FROM (SELECT TOP 100...

dec 9
2 views

SELECT t1._year, t1._count/t2._count FROM (SELECT TOP 100...

dec 9
1 view

select owneruserid, min(creationdate), datediff(year, min...

dec 9
1 view

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
188 views

Top Users by location and tag

dec 9 jon.doe31543
1 view

SELECT * FROM (SELECT TOP 100 year(creationdate) AS _year...

dec 9
188 views

Top Users by location and tag

dec 9 jon.doe31543
1 view

select owneruserid, min(creationdate) from posts group by...

dec 9
1 view

select owneruserid, min(creationdate) from posts group by...

dec 9
1 view

SELECT * FROM (SELECT TOP 100 year(creationdate) AS _year...

dec 9
2 views

select top 1 owneruserid, creationdate from posts

dec 9
1 view

select OwnerUserId,id,CreationDate,Title from posts p whe...

dec 9
1 view

SELECT * FROM (SELECT TOP 100 year(creationdate) AS _year...

dec 9
1

13 views

Fourth

dec 9 Kamushek
1 view

select OwnerUserId,id,CreationDate,Title from posts p ord...

dec 9
1

13 views

Fourth

dec 9 Kamushek
1 view

select top 1 owneruserid, creationdate from posts where o...

dec 9
1 view

SELECT * FROM (SELECT TOP 100 * FROM posts) t

dec 9
1 view

select top 1 owneruserid, creationdate from posts order b...

dec 9
188 views

Top Users by location and tag

dec 9 jon.doe31543
188 views

Top Users by location and tag

dec 9 jon.doe31543
1

13 views

Fourth

dec 9 Kamushek
1

13 views

Fourth

dec 9 Kamushek
188 views

Top Users by location and tag

dec 9 jon.doe31543
1 view

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
1 view

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
188 views

Top Users by location and tag

dec 9 jon.doe31543
188 views

Top Users by location and tag

dec 9 jon.doe31543
2 views

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
2 views

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
30 views

select datediff(year, '2008-08-23 00:00:00','2009-08-24 0...

dec 9 Kamushek
1 view

WITH IcelandUsersPosts AS ( SELECT p.id FROM Posts AS p I...

dec 9
30 views

select datediff(year, '2009-08-31 00:00:00','2008-08-31 0...

dec 9 Kamushek
30 views

select datediff(year, '2008-08-31 00:00:00','2008-08-31 0...

dec 9 Kamushek
30 views

select datediff(day, '2008-08-31 00:00:00','2008-01-31 00...

dec 9 Kamushek
30 views

select datediff(day, '2008-07-31 00:00:00','2008-08-31 00...

dec 9 Kamushek
30 views

select datediff(day, '2008-07-31 00:00:00','2008-07-31 00...

dec 9 Kamushek

30 50 100 per page

1,412,289

queries

Q&A about the site for members of the workforce navigating the professional setting

1.6k questions

3.4k answers

16k comments

124 tags

dec 8 most recent