I have a very simple doubt. Say for e.g, I have the following table, Employee :
Name ID Salary
A 1 14500
B 2 25100
C 3 20000
D 4 9000
E 5 7500
and I run the below query :
select * from Employee (nolock) where Salary in(14500,25100,20000,9000)
My questions :
1) How would the order of the result set of the above query be decided WITHOUT an ORDER BY CLAUSE.
2) Can I control the order of the output in the order in which the parameters are passed in the "in" clause ? i.e I want the record with salary value "14500" to appear first followed by 25100 and so on ?
Knowledge sharing would be appreciated. :)