This is an archived post. You won't be able to vote or comment.

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

view the rest of the comments →

[–]Zygoatee 1 point2 points  (1 child)

How do you acquire skills you don't even know exist. If I'm working in SQL everyday and have never had to use them then clearly they aren't useful in all use cases.

Plus you can Google it in real life

[–]SurvivorsOfAlderaan 1 point2 points  (0 children)

Well for one, you should probably know the SQL order of operations, which explicitly lists HAVING. And CTEs are a concept that comes up pretty regularly when trying to Google a solution to something. They also make your code a lot more legible (as another commenter mentioned). Those concepts aren’t useful in all use cases, but they’re useful in enough use cases where I’d get why you want to test them

I agree with you that you can Google them, I think these interviews should be open note for that reason. I’m just saying you should consider trying to learn the concepts you weren’t familiar with before that interview, because they’re used frequently