sorting but always having specified fields come up first

zxcvbs · #1 (**permalink**) 11-14-06, 17:32

is there a way to sort by a field, but have specified fields always appear first?

e.g.:

ID | DATA
1 | ...
2 | ...
3 | ...
4 | ...
8 | ...
10 | ...

I want to retrieve all records ordered by ID ascending, but I want records 8 and 10 to always be first, so the retrieval looks like:

ID | DATA
8 | ...
10 | ...
1 | ...
2 | ...
3 | ...
4 | ...

I know it sounds kind of dumb, but it's kind of the way it is for now. any way to do this without having to use multiple queries?

r937 · #2 (**permalink**) 11-14-06, 17:57

Code:

order
    by case when id in (8,10) then 0 else 937 end
     , id

zxcvbs · #3 (**permalink**) 11-15-06, 09:20

worked perfectly. thanks!

Internet Services

Web Development

Digital Marketing

Consumer Tech