SQL: Just like tables, IN clauses have no default order

added by DotNetKicks
10/31/2019 5:09:37 PM

225 Views

In Stack Overflow, I saw a poster with a query like this: [crayon-5db9fabc8b068040119890/] And he was frustrated that he couldn't reliably get an ordered output like this: [crayon-5db9fabc8b070170961565/] The problem is that he was assuming that the IN clause had a specified order that was then obeyed by the SELECT statement.


0 comments