4 ms·
Having vs where is my first question to filter candidates who have less experience in sql than they claim.
by higeorge13 4y ago
Having vs where is my first question to filter candidates who have less experience in sql than they claim.
- notimetorelax 4y agoWell, 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.