Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

159 views

SELECT post.CreationDate AS PostCreationDate, answer.Crea...

sep 16 jon.doe45714
13 views

SELECT P.Id, P.PostTypeId, C.Id, C.PostTypeId FROM Posts ...

sep 16
159 views

SELECT * FROM Posts post INNER JOIN Posts answer ON answe...

sep 16 jon.doe45714
159 views

SELECT * FROM Posts WHERE Id = '73790499' AND PostTypeId ...

sep 16 jon.doe45714
34 views

SELECT AVG(CAST(DATEDIFF(minute, q.CreationDate, a.Creati...

sep 16 jon.doe45714
159 views

SELECT * FROM Posts WHERE Id = '73790499'

sep 16 jon.doe45714
14 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
14 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
34 views

SELECT AVG(CAST(DATEDIFF(minute, q.CreationDate, a.Creati...

sep 16 jon.doe45714
159 views

SELECT * FROM Posts WHERE Id = '73642970';

sep 16 jon.doe45714
14 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
34 views

SELECT AVG(CAST(DATEDIFF(minute, q.CreationDate, a.Creati...

sep 16 jon.doe45714
14 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
14 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
14 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
14 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
14 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
14 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
13 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
12 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
12 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
12 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
12 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
12 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
12 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
11 views

WITH dr(dd) AS ( SELECT cast('2024-01-01' as date) UNION ...

sep 16 jon.doe45713
11 views

WITH DateRange(DateData) AS ( SELECT cast('2024-01-01' as...

sep 16 jon.doe45713
11 views

DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SE...

sep 16 jon.doe45713
11 views

DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SE...

sep 16 jon.doe45713
13 views

DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SE...

sep 16 jon.doe45713
13 views

DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SE...

sep 16 jon.doe45713
12 views

DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SE...

sep 16 jon.doe45713
13 views

DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SE...

sep 16 jon.doe45713
16 views

DECLARE @StartDateTime DATETIME DECLARE @EndDateTime DATE...

sep 16 jon.doe45713
14 views

select max(creationdate) from comments

sep 16 jon.doe45713
12 views

select top(10)* from comments

sep 16 jon.doe45713
13 views

select * from comments

sep 16 jon.doe45713
15 views

DECLARE @StartDateTime DATETIME DECLARE @EndDateTime DATE...

sep 16 jon.doe45713
28 views

Tags

sep 16 Faramir
13 views

SELECT c2.postid, c2.text FROM (SELECT c.postid, MAX(c.id...

sep 16 jon.doe45713
14 views

SELECT c.postid, MAX(c.id) max_id FROM comments c GROUP B...

sep 16 jon.doe45713
13 views

SELECT c.postid, MAX(c.id) max_id FROM comments c GROUP B...

sep 16 jon.doe45713
14 views

SELECT c.postid, MAX(c.id) max_id FROM comments c GROUP B...

sep 16 jon.doe45713
14 views

SELECT c.postid, MAX(c.id) max_id FROM comments c GROUP B...

sep 16 jon.doe45713
20 views

SELECT c2.postid, c2.text FROM (SELECT postid, MAX(creati...

sep 16 jon.doe45713
22 views

SELECT c2.postid, c2.text FROM (SELECT postid, MAX(creati...

sep 16 jon.doe45713
24 views

Lowest voted posts

sep 16
19 views

select * from (select postid, rank() over (partition by p...

sep 16 jon.doe45713
19 views

select * from (select postid, rank() over (partition by p...

sep 16 jon.doe45713
18 views

select postid, rank() over (partition by postid order by ...

sep 16 jon.doe45713

30 50 100 per page

2,250,993

queries

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

159 questions

299 answers

1.2k comments

72 tags

mar 13 most recent