Posted on 2014-04-14
Was asked 2 sql related questions in a job interview the other day. I obviously didn't get the job. Here are the questions:
#1. I have 2 tables, A & B, and I want to return the rows from A that are NOT on B? How would I do it in one select statement. I didn't think a <> on a join would work and said I thought a subquery might be required. In Access I would have tagged set a column on A and flagged the rows that did = B. But I'm sure there must be a better solution than that.
#2. How would I control the sort on nested queries.
It's worth noting that this was for a BSA job…not a developer.