When I work on sql queries I usually start with a base query and edit as I go depending on the requirements, sometimes running the query and debugging. However, after being in a sql interview it seems like this approach doesn’t work the best for interviews as I frequently go down the wrong path before correcting myself, and especially not in situations where I can’t actually run intermediate queries.
What’s a good approach for working out a sql query in a structured way?
FoldFold allExpandExpand allAre you sure you want to delete this link?Are you sure you want to delete this tag?
The personal, minimalist, super-fast, database free, bookmarking service by the Shaarli community