4 ms·
Well, I used SQL professionally for at least 7 years in different capacities and “having” was a new construct to me. You might say that I suck at SQL or you mi
by notimetorelax 4y ago
Well, I used SQL professionally for at least 7 years in different capacities and “having” was a new construct to me. You might say that I suck at SQL or you might realize that there’s more than one way to achieve a result in SQL. I usually prefer “with” statements. I hope this is not the only criteria you use to filter candidates.
In my mind a better question would be to state the problem and see if the candidate can come up with a working SQL statement.
- higeorge13 4y agoI would ask you more questions like window functions, cte, joins, etc. or how would you address certain questions, and tbh i would be really curious that you know good sql but haven’t heard of having. In my hiring experience it always acted as my first sql impression of candidates and 100% filter of people who don’t actually know sql besides some basic inner joins and aggregations. There are always exceptions i guess. :-)
- SnowHill9902 4y agoIt’s also a hint that the candidate is not curious and doesn’t thoroughly read the docs which is a minus.