Sequence is changed in resultant

Question

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 5-May-12 3:18am

shikhar gilhotra

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

ZurdoDev · Answer 1 · 2012-05-07T13:50:00

Solution 1

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.

Posted 7-May-12 13:50pm

ZurdoDev