You are viewing a single comment's thread. Return to all comments →
you can't use cte because hackerrank is using mysql < 8.0. if you wanna use cte, you can change mysql to ms sql server.
check the link below https://stackoverflow.com/questions/72134462/tried-using-cte-on-hackerrank-its-not-working-what-could-be-the-alternate-sol
Seems like cookies are disabled on this browser, please enable them to open this website
Interviews
You are viewing a single comment's thread. Return to all comments →
you can't use cte because hackerrank is using mysql < 8.0. if you wanna use cte, you can change mysql to ms sql server.
check the link below https://stackoverflow.com/questions/72134462/tried-using-cte-on-hackerrank-its-not-working-what-could-be-the-alternate-sol