sql – 不使用order by子句对结果进行排序

解决方法

某些SQL实现可能会按主键或聚簇索引的顺序返回行,但SQL本身是一个关系代数,它返回任意有序的集合,除非另有说明.

返回行的顺序很可能很大程度上取决于创建表后的插入和删除活动.

我对这样的面试问题的回答是：

Is there some sort of reason why we can’t use ‘order by’ in our queries? Is the company so hard up for money that they cannot afford the disk space to store those extra few bytes for each query? Are you out of you goddamned mind? Ask me a question that’s going to have some relevance

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!