Help with order by case... syntax with mimer db
- From: dos.fishing@xxxxxxxxx
- Date: Tue, 10 Jul 2007 03:37:08 -0700
I'm working with mimer mobile db and need som help with the following
statement in a procedure.
I have the following today:
SELECT column1 FROM table1
ORDER BY case when some_expression then column2 else column3
end;
I would like to do the following but the syntax seems to be wrong:
SELECT column1 FROM table1
ORDER BY case when some_expression then coloumn1, column2 else
coloumn3, column4 end;
i.e. add some more columns to the order expression.
Alternatively, I would like to do something like:
SELECT column1 FROM table1{INDEX case when some_expression then index1
else index2 end};
where index1 and index2 are indexes created for table1.
Any idea's of how to accomplish this?
Cheers
//Kid
.
- Follow-Ups:
- Re: Help with order by case... syntax with mimer db
- From: Lennart
- Re: Help with order by case... syntax with mimer db
- Prev by Date: Re: Firebird, Microsoft Express, Postgre, or Virtuoso?
- Next by Date: Re: Help with order by case... syntax with mimer db
- Previous by thread: Getting one of many possible pairings between 2 rows
- Next by thread: Re: Help with order by case... syntax with mimer db
- Index(es):
Relevant Pages
|
|
