multiple order_by clauses?

[prev] [thread] [next] [Date index for 2005/06/15]

Hi all, 

I was wondering if it's possible to specify multiple order_by clauses as
you can in standard SQL, where there are fallbacks in ordering in the
event that the first order_by qualifier is the same?

The equivalent of:

SELECT CATEGORY.NAME FROM CATEGORY ORDER BY CATEGORY.RANK, CATEGORY.NAME

Thanks -- if I need to drop to Perl for this that's fine, but I figured
it's probably implemented but not documented.

d. Taylor Singletary