-1

This question already has an answer here:

In the case where you've specified the following list of numbers, which are in random order, will the results be in the same order?

where item in
(
    371355,
    371476,
    371629,
    370556,
    370677,
    370820,
    370952,
    371070,
    371223,
    372154,
    372253,
    371751,
    371872
)

marked as duplicate by Philᵀᴹ, LowlyDBA, Michael Green, ypercubeᵀᴹ, Andriy M Aug 2 '16 at 14:55

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 7
    No. If there is no ORDER BY in the query, the results can be in arbitrary order. See a similar question: Does an IOT guarantee order in a select? that has the same exact answer: "The only thing that guarantees result set order is an ORDER BY clause in your query." – ypercubeᵀᴹ Aug 1 '16 at 13:56
3

NO,

If you do want them to be in order (asc, desc) here is how you would query it...

SELECT T.ITEM
FROM TABLE T
WHERE T.ITEM IN ( 371355
              , 371476
              , 371629
              , 370556
              , 370677
              , 370820
              , 370952
              , 371070
              , 371223
              , 372154
              , 372253
              , 371751
              , 371872
              )
ORDER BY T.ITEM DESC

Not the answer you're looking for? Browse other questions tagged or ask your own question.