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)

Computer Science Educators

Q&A for those involved in the field of teaching Computer Science

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