News for hackers. Stuff that matters.

A comment on Medium-hard SQL interview questions. Parent comment

Re:Medium-hard SQL interview questions by minimaxir on Saturday May 02, 2020 @06:12PM (#23055314)
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.)
[ Parent | on HN ]
Re:Medium-hard SQL interview questions by shostack on Saturday May 02, 2020 @11:04PM (#23056586)
"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?"
[ Parent | on HN ]
Re:Medium-hard SQL interview questions by lonelappde on Saturday May 02, 2020 @07:00PM (#23055560)
You dodged a bullet with that one.
[ Parent | on HN ]
Re:Medium-hard SQL interview questions by WoahNoun on Saturday May 02, 2020 @07:04PM (#23055583)
Definitely 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.
[ Parent | on HN ]
Re:Medium-hard SQL interview questions by truculent on Sunday May 03, 2020 @06:59AM (#23058251)
What a jerk. Sorry that happened to you.
[ Parent | on HN ]
Re:Medium-hard SQL interview questions by malinens on Sunday May 03, 2020 @03:43AM (#23057527)
sounds like he is some old guy who is afraid to loose his position and is gatekeeping so he can keep his current job...
[ Parent | on HN ]