Click here to Skip to main content
15,947,411 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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.
Posted
Comments
OriginalGriff 5-May-12 9:39am    
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.
Sandeep Mewara 5-May-12 10:53am    
What's the issue to use ORDER BY?
Darshan.Pa 5-May-12 12:18pm    
why you dont want to use order by in your query.
it will not slow down your server...
Sergey Alexandrovich Kryukov 6-May-12 20:23pm    
Reason for my vote of 1
This is not a correct question. If you are asking "how to do this or that?", you should not say "using this or that"; or at least you need to motivate it.

Who would be interested in answering questions which might be useless?

For your information, database does not assume any certain order of records. Without "order by" the order is simply unpredictable.

--SA

1 solution

Quote:
same sequence

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.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900