Details for linjomlinjom has participated in the following threads:
Added by bhilarev on 25 Oct 2017 at 07:14
I just get only four rows ,
From Author As x
INNER JOIN Episode As y
ON x.AuthorId = y.AuthorId
Where Title Like '%Daleks%';
Is this query correct?
Added by grao on 07 Nov 2017 at 01:34
I am not getting any results. Is this the right code?
from tblCompanion as c
left outer join tblEpisodeCompanion as e
where e.EpisodeCompanionId =null
Added by linjom on 17 Apr 2018 at 13:17
I could solve till the second last requirement. The final one seems tough .... can anyone help with the trick?
Added by linjom on 23 Apr 2018 at 07:33
I am getting different result..
18th Century 4
19th Century 14
20th Century 396
21st Century 45
for both rollup and cube.. is this right? Final total same as site.