结果中的顺序已更改 [英] Sequence is changed in resultant

问题描述

我有一个表，该表的其中一个列中有记录为
a
b
c
d
e
.
.
.
现在，我在SQL2008中写了一个查询(没有在任何地方使用Orderby)，更改了它的顺序.我想要具有相同序列的结果列查询结果.

Hi, I hav a table which have records in one of its column as
a
b
c
d
e
.
.
.
Now, i wrote a query(without using Orderby anywhere)in SQL2008 which changed its sequence. I want the resultant column query result with same sequence. How to do that.

推荐答案

报价:

相同顺序

您需要使用执行计划或仅查看表上的索引，它会向您显示如何对其进行排序，然后您可以执行相同的操作.

You need to use the execution plan or just look at the indexes on the table and it will show you how it is being sorted and then you can do the same thing.

这篇关于结果中的顺序已更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！