[SQL] Order By Question

2001-01-23 Thread Tristan Colson
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, the

[SQL] Order By Question

2001-01-23 Thread Tristan Colson
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 having field2 = 3, then field2 = 1, then field2 = 2. As it