Geek Answers Handbook

Sort Order of results for Select WITHOUT WHERE or ORDER BY

I have a table with a PK clustered index, as well as other indexes on it, both unique and inimitable. If I give out (for sure):

SELECT * FROM table_name

or

SELECT col1, col2 FROM table_name

in what order will the rows be returned?

This is the first question in the questionnaire that the client sent to us. Here are the instructions:

If the answer to this question is incorrect, immediately stop the interview! A person, regardless of their declared abilities, does not understand the SQL-based relational database management system. This is the logic of SQL-101 over the past 25 years. The correct answer is "unknown / random / undetermined because the ORDER BY clause was not specified as part of the request."

I’m somehow not convinced that this is really correct. All comments are welcome.

Thank,

Rajah

+5
2

/, . /, , - .

, , . , " " - .. , , .

+8

SQL , , . , SQL , RDBMSs , .

+5

More articles:


All Articles