kokok_kokok wrote:

> Simplifying the problem, I want the 10 first records, ordered by "a desc, b"
>
> select first 10 * from fo order by a desc, b
>
> My question is: how can I create an index

What is the datatype of A and B?

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================