3 ms·
That was incidentally the exact question I was asked. (When I asked during the interview "I know you need to use a SUM window function but I'm not sure how you
by minimaxir 7y ago
That was incidentally the exact question I was asked. (When I asked during the interview "I know you need to use a SUM window function but I'm not sure how you constrain it to the past 7 days", the interviewer replied "you don't know the BETWEEN syntax? Everyone knows that." And then the interview ended.)
- lonelappde 7y agoYou dodged a bullet with that one.
- WoahNoun 7y agoDefinitely not cool to use syntax as an interview question, but it is a very powerful tool so I wouldn't write it off because of one interview.
- shostack 7y ago"In a real world situation I'd have googled it and jogged my memory in less than a minute. Since I suspect you were more interested in how I would approach solving X, can you help refresh my memory on the syntax and we can pretend I looked it up to get back to what's important here?"
- malinens 7y agosounds like he is some old guy who is afraid to loose his position and is gatekeeping so he can keep his current job...
- truculent 7y agoWhat a jerk. Sorry that happened to you.