3 ms·
The great thing about it is that it's just one SQL statement. One SQL statement with recursion ughhh, arghhhh ... a bit older but still quite complicated to me
by polsoul 11y ago
The great thing about it is that it's just one SQL statement.
One SQL statement with recursion ughhh, arghhhh ... a bit older but still quite complicated to me - I've spent many hours on it and still cannot fully understand how it works(this recursion thingy with all the university variables memories - i,k,j , do you remember them :)). Definitely a good brain teaser, good luck.
- polsoul 11y agoPretty easy to test it using: http://sqlfiddle.com/ http://sqlfiddle.com/ (just select Oracle 11g R2 instead of MySQL from the drop down -> press Build Schema -> paste the SQL statment into the right window -> Run SQL )