-1

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
)
dnoeth
  • 4,206
  • 13
  • 14
rmgross1
  • 7
  • 1

1 Answers1

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
Hector
  • 1,042
  • 1
  • 8
  • 22