Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

275 views

declare @orders table (CustomerID int, OrderID int, Produ...

feb 16 12
221 views

declare @orders table (CustomerID int, OrderID int, Produ...

feb 16 12
147 views

select DATEADD(week, DATEDIFF(week, 0, creationdate), 0)...

feb 16 12
181 views

select DATEADD(dd, DATEDIFF(dd, 0, creationdate), 0), vo...

feb 16 12
233 views

declare @orders table (CustomerID int, OrderID int, Produ...

feb 16 12
194 views

declare @orders table (CustomerID int, OrderID int, Produ...

feb 16 12
127 views

declare @orders table (CustomerID int, OrderID int, Produ...

feb 16 12
194 views

declare @orders table (CustomerID int, OrderID int, Produ...

feb 16 12
233 views

declare @orders table (CustomerID int, OrderID int, Produ...

feb 16 12
221 views

declare @orders table (CustomerID int, OrderID int, Produ...

feb 16 12
275 views

declare @orders table (CustomerID int, OrderID int, Produ...

feb 16 12
4.5k views

Number of posts for a selected tag, broken down by month and year

feb 16 12 jon.doe7330
4.5k views

Number of posts for a selected tag, broken down by month and year

feb 16 12 jon.doe7330
294 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
327 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
282 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
289 views

select * from posts where id = 45856

feb 16 12
330 views

select * from posts where id = 135383

feb 16 12
336 views

select * from posts where id = 135383 select DATEADD(wee...

feb 16 12
267 views

select * from postfeedback where postid = 135383

feb 16 12
255 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
293 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
285 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
341 views

select votetypes.name, DATEADD(week, DATEDIFF(week, 0, Cr...

feb 16 12
253 views

select votetypeid, DATEADD(week, DATEDIFF(week, 0, Creati...

feb 16 12
281 views

Select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0) ...

feb 16 12
216 views

WITH Scores as ( SELECT SCORE, ROW_NUMBER() OVER (ORDER ...

feb 16 12 conradfrix
253 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
161 views

SELECT DISTINCT SCORE , row_number() Over (order by score...

feb 16 12 conradfrix
257 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0) ...

feb 16 12
274 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0) ...

feb 16 12
327 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
273 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
250 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
266 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
199 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
265 views

select * from votetypes

feb 16 12
238 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
236 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
277 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
183 views

select DATEADD(week, DATEDIFF(week, 0, CreationDate), 0),...

feb 16 12
93 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
183 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
277 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
236 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
238 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
199 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
266 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
250 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
273 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
327 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
274 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
257 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
253 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
281 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
253 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
341 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
285 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
293 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
255 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
267 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
336 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
330 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
289 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
282 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
327 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
294 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
181 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
147 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
233 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
163 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
216 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
194 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
179 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
243 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
202 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
208 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
213 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
247 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
227 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
110 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
127 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
128 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
155 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
148 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
181 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
116 views

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEP...

feb 16 12
117 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
265 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
1.4k views

SELECT * FROM Users where Location LIKE '%Canada%' ORDER ...

feb 16 12 Mark Peters
643 views

SELECT * FROM Users where Location LIKE '%Canada%' ORDER ...

feb 16 12 Mark Peters
1.4k views

SELECT * FROM Users where Location LIKE '%Waterloo%' OR L...

feb 16 12 Mark Peters
643 views

SELECT * FROM Users where Location LIKE '%Waterloo%' OR L...

feb 16 12 Mark Peters
1.4k views

SELECT * FROM Users where Location LIKE '%Waterloo%' ORDE...

feb 16 12 Mark Peters
643 views

SELECT * FROM Users where Location LIKE '%Waterloo%' ORDE...

feb 16 12 Mark Peters
279 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
273 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
276 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
273 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
280 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
291 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
1.4k views

SELECT * FROM Users where Location LIKE '%Waterloo%' AND ...

feb 16 12 Mark Peters
643 views

SELECT * FROM Users where Location LIKE '%Waterloo%' AND ...

feb 16 12 Mark Peters
148 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
291 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
280 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
273 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
276 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
273 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12
279 views

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DAT...

feb 16 12

30 50 100 per page

1,931,775

queries

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

671 questions

1.4k answers

2.9k comments

116 tags

may 22 most recent