select * from (select count(id) as posty, cast(creationda...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature Meta

Q&A about the site for scholars and enthusiasts of literature

select *
from (select count(id) as posty, cast(creationdate as date) as datka 
      from Posts group by cast(creationdate as date)) as table1,
      (select count(id) as posty, cast(creationdate as date) as datka 
      from Posts group by cast(creationdate as date)) as table2
where table1.datka = table2.datka

Enter Parameters

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