CREATE TABLE test (blob_col BLOB, INDEX(blob_col(10)));

0

Please login or register to vote for this query.

(click on this box to dismiss)

History

Q&A for historians and history buffs

SELECT *
FROM
(	
SELECT DISTINCT OwnerUserId AS Owner FROM Posts
WHERE 
CreationDate BETWEEN DATEADD(day, 7, '2008-08-01') AND 
DATEADD(day, 8, '2008-08-01')
) t1
INNER JOIN
(
SELECT DISTINCT OwnerUserId AS Owner FROM Posts
WHERE 
CreationDate BETWEEN DATEADD(day, 1, '2008-08-01') AND 
DATEADD(day, 2, '2008-08-01')
) t2 ON t2.Owner = t1.Owner

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results