We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
I tried your code and it doesn't work. I think that is because hackerrank doen't support CTE(WITH clause). Moreover, would you please exlain how does this work——
SELECT TOTALCNT FROM COUNTS AS T
WHERE H.HACKER_ID != T.HACKER_ID
thank you
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Challenges
You are viewing a single comment's thread. Return to all comments →
I tried your code and it doesn't work. I think that is because hackerrank doen't support CTE(WITH clause). Moreover, would you please exlain how does this work—— SELECT TOTALCNT FROM COUNTS AS T WHERE H.HACKER_ID != T.HACKER_ID thank you