Stack Exchange
log in
help
Stack Exchange Data Explorer
Home
Queries
Users
Compose Query
OMG Ponies
Registered User
member for
5319 days
seen
Mar 17 '11 at 1:12
location
edited
favorite
recent
Cummulate Date Difference Calculation
WITH sample AS ( SELECT 'MindWorks.Accounts' AS col UNION...
WITH sample AS ( SELECT 'MindWorks.Accounts' AS col UNION...
WITH sample AS ( SELECT 'MindWorks.Accounts' AS col UNION...
WITH sample AS ( SELECT 'MindWorks.Accounts' AS col UNION...
WITH sample AS ( SELECT 'MindWorks.Accounts' AS col UNION...
SELECT DATEPART(dw, LastActivityDate) FROM Posts
RANK, parition by id order by value_type
Cummulative Date Difference Calculation
Divid By Zero Test
WITH test AS ( SELECT CAST(NULL AS DATETIME) AS dt) SELE...
SELECT SUBSTRING('abcd_01', LEN('abcd_01') - 1, 2)
SELECT SUBSTRING('abcd_01', LEN('abcd_01') - 2, 2)
How Old are You
How Old are You
1
2
next
Data Explorer works best with JavaScript enabled