Stack Exchange Data Explorer
Nov 15 '17 at 22:15
select count(distinct u.Id)*100.0/count(distinct isnull(c...
Most duplicated questions
Duplicates for a given post
DECLARE @MyUserID INT = ##UserID:int## SELECT TOP 1 Id A...
select PostId as [Post Link], UserId as [User Link], coun...
DECLARE @Today datetime = GetDate(); select count(*) fro...
select * from Users where Id=1168492
select * from Comments where CreationDate < '7/1/2012' an...
Hard to delete
select PostId as [Post Link] from Comments where Text lik...
select Id as [Post Link] from Posts where Body like '%tea...
select PostId as [Post Link], Text from Comments where Te...
Some funky punctuation
site design / logo © 2019 Stack Exchange Inc; user contributions licensed under
cc by-sa 3.0