This seems like the answer must be pretty easy, but I can't think of it: In the following statement: select field1 from my_table where field2 in (3, 1, 2); How can I modify this statement so that the record are returned in the order of first those records having field2 = 3, then field2 = 1, then field2 = 2. As it stands, I am getting them returned in the order of the value of field1.
- [SQL] Order By Question Tristan Colson
- [SQL] Re: Order By Question Tristan Colson
- [SQL] Re: Order By Question Ian Harding
- Re: [SQL] Order By Question Prasanth Kumar