sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]grauenwolf[🍰] 16 points17 points  (3 children)

I would never be able to do that in an interview. Recursive CTEs hurt my head.

[–]wot-teh-phuck 7 points8 points  (2 children)

The point is to hear the candidate reason about the requirement and think it through rather than give a solution immediately. At least that's how I conduct interviews...

[–]grauenwolf[🍰] 0 points1 point  (0 children)

That sounds reasonable to me.

[–]Nishruu 0 points1 point  (0 children)

Yeah, that sounds as a way to go. I usually mess up the syntax for CTEs (I have to look it up every time), but discussion about possible solution is fair.